MySQL Tutorial/Regular Expressions/Any Character

Материал из SQL эксперт
Перейти к: навигация, поиск

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>