Regular Expression MySQL

  1. Home
  2. MySQL
  3. Regular Expression
  4. 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)