Same character 3 times condition in mysql

Question

I want a query (in msyql) to get records with same character 3 times:

aa => false
aaa => true
baaa => true
aaab => true
aaaaaab => true
baaab => true
babababa => false

For any character, not only 'a' and 'b'.

The following sentence doesn't work:

SELECT field1
FROM mytable
WHERE field1 REGEXP '(.)\1\1';

Answer 1

May be this can help you.

select * from test1 where name REGEXP  '[a]{3}|[b]{3}|[c]{3}|[d]{3}|[e]{3}|[f]{3}|[g]{3}|[h]{3}|[i]{3}|[j]{3}|[k]{3}|[l]{3}|[m]{3}|[n]{3}|[o]{3}|[p]{3}|[q]{3}|[r]{3}|[s]{3}|[t]{3}|[u]{3}|[v]{3}|[w]{3}|[x]{3}|[y]{3}|[z]{3}';  

It returns records for 3 same and consecutive letters.