Match any character (including carriage return and newline) : Any Character : Regular Expressions MySQL TUTORIALS

MySQL TUTORIALS » Regular Expressions » Any Character »

Match any character (including carriage return and newline)


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

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

mysql>