MySQL Tutorial/Regular Expressions/Any Character
Match any character (including carriage return and newline):.
<source lang="sql">
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></source>