Regular expressions in MySQL

The regular expressions in MySQL are represented in the same way as in Linux, and MySQL provides regular expression functionality through the RegExp command:

A (m,n) matches m to n a

A (, N) matches 0 to n a

[Email protected]:cyz--08:14:42 >create table test (ID int auto_increment primary key,email varchar (20));
Query OK, 0 rows affected (0.01 sec)

[Email protected]:cyz--08:15:03 >insert into test values (1, ' [email protected] '), (2, ' [email protected] '), (3, ' [email Protected] ');
Query OK, 3 Rows Affected (0.00 sec)
Records:3 duplicates:0 warnings:0

[Email protected]:cyz--08:16:14 >select * FROM test where email regexp ' [1.] ';
+----+-------------+
| ID | email |
+----+-------------+
| 1 | [Email protected] |
| 2 | [Email protected] |
| 3 | [Email protected] |
+----+-------------+
3 Rows in Set (0.00 sec)

Regular expressions in MySQL