Match any sequence of one or more a characters: a+ : One or More « Regular Expressions « MySQL Tutorial






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>








24.9.One or More
24.9.1.Match any sequence of one or more a characters: a+
24.9.2.Get first name with one or more J character: J+