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