Match the beginning of a string : Anchor Start : Regular Expressions MySQL TUTORIALS

MySQL TUTORIALS » Regular Expressions » Anchor Start »

Match the beginning of a string


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

mysql>
mysql> SELECT 'AA' REGEXP '^A';
+------------------+
| 'AA' REGEXP '^A' |
+------------------+
|                1 |
+------------------+
1 row in set (0.00 sec)

mysql>