Match the end of a string : Anchor End : Regular Expressions MySQL TUTORIALS

MySQL TUTORIALS » Regular Expressions » Anchor End »

Match the end of a string


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

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

mysql>