Match zero or more instances of the sequence abc : Sequence : Regular Expressions MySQL TUTORIALS

MySQL TUTORIALS » Regular Expressions » Sequence »

Match zero or more instances of the sequence abc


mysql>
mysql> SELECT 'ABC' REGEXP '^(ABC)*$';
+-------------------------+
| 'ABC' REGEXP '^(ABC)*$' |
+-------------------------+
|                       1 |
+-------------------------+
1 row in set (0.00 sec)

mysql>
mysql> SELECT 'ABC' REGEXP '^(AB)*$';
+------------------------+
| 'ABC' REGEXP '^(AB)*$' |
+------------------------+
|                      0 |
+------------------------+
1 row in set (0.00 sec)

mysql>
mysql> SELECT 'ABCABC' REGEXP '^(AB)*$';
+---------------------------+
| 'ABCABC' REGEXP '^(AB)*$' |
+---------------------------+
|                         0 |
+---------------------------+
1 row in set (0.00 sec)

mysql>