Mega Code Archive

 

Categories / MySQL Tutorial / Regular Expressions

 

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