Match any sequence of one or more a characters : One or More : Regular Expressions MySQL TUTORIALS

MySQL TUTORIALS » Regular Expressions » One or More »

Match any sequence of one or more a characters


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

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

mysql>