Regular Expression MySQL

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