mysql中的正则表达式表示方式跟linux中其实是一样的，mysql通过REGEXP命令提供正则表达式功能：
a(m,n)匹配m到n个a
a(,n)匹配0到n个a
root@localhost:cyz--08:14:42 >create table test(id int auto_increment primary key,email varchar(20));
Query OK, 0 rows affected (0.01 sec)
root@localhost:cyz--08:15:03 >insert into test values(1,'abc@163.com'),(2,'def@162.com'),(3,'jjj@111.com');
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
root@localhost:cyz--08:16:14 >select * from test where email regexp '[1.]';
+----+-------------+
| id | email |
+----+-------------+
| 1 | abc@163.com |
| 2 | def@162.com |
| 3 | jjj@111.com |
+----+-------------+
3 rows in set (0.00 sec)