Mega Code Archive

 

Categories / MySQL / Regular Expression

 

To match abcabcabc, you need to use parentheses

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