Mega Code Archive

 

Categories / MySQL / Regular Expression

 

{3,} means the a must occur at least three times

mysql> mysql> SELECT 'aaaa' REGEXP 'a{3,}'; +-----------------------+ | 'aaaa' REGEXP 'a{3,}' | +-----------------------+ |                     1 | +-----------------------+ 1 row in set (0.00 sec)