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






  1. MySQL Tutorial
  2. Regular Expressions
  3. Occurrences
mysql>
mysql>
mysql> SELECT 'abcde' REGEXP 'a[bcd]{3}e';
+-----------------------------+
| 'abcde' REGEXP 'a[bcd]{3}e' |
+-----------------------------+
|                           1 |
+-----------------------------+
1 row in set (0.02 sec)








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';