SELECT 'abcde' REGEXP 'a[bcd]{1,10}e'; : Occurrences « Regular Expressions « MySQL Tutorial






  1. MySQL Tutorial
  2. Regular Expressions
  3. Occurrences
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>








24.8.Occurrences
24.8.1.{n} or {m,n} notation provides a more general way of writing regular expressions: {1}, {2,3}
24.8.2.SELECT 'abcde' REGEXP 'a[bcd]{3}e';
24.8.3.SELECT 'abcde' REGEXP 'a[bcd]{1,10}e';