页次: 1
格式
select * from 表 where 字段名 regexp '正则表达式'
示例
创建一个表
mysql> create table r( name varchar(80) ); Query OK, 0 rows affected (0.41 sec) mysql> insert into r (name) values ('aaaa'), ('aabb'), ('abc'), ('adda'), ('acca'); Query OK, 5 rows affected (0.04 sec) Records: 5 Duplicates: 0 Warnings: 0
查询c结尾的
mysql> select * from r where name regexp 'c$' -> ; +------+ | name | +------+ | abc | +------+ 1 row in set (0.02 sec)
查询a 开头 a结尾的
mysql> select * from r where name regexp '^a.*a$'; +------+ | name | +------+ | aaaa | | adda | | acca | +------+ 3 rows in set (0.00 sec)
ipbbs.net
离线
页次: 1