MySQL Tutorial/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 "A\r\nB" REGEXP "^A.*$";
+-------------------------+
| "A\r\nB" REGEXP "^A.*$" |
+-------------------------+
|                       1 |
+-------------------------+
1 row in set (0.00 sec)
mysql>