mysql>
mysql> SELECT 'abcde' REGEXP 'a[bcd]{1,10}e';
+--------------------------------+
| 'abcde' REGEXP 'a[bcd]{1,10}e' |
+--------------------------------+
| 1 |
+--------------------------------+
1 row in set (0.00 sec)
mysql>