Regular Expressions MySQL Tutorial

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