regexp '^a' 表示以a开头
regexp ‘a$’ 表示以a结尾
regexp ' a'表示包含a
实例
select * from tcount_tbl;
+----------+-------+
| author | count |
+----------+-------+
| z | 20 |
| a | 20 |
| b | 0 |
| g | 0 |
| j | 1 |
| s | 1 |
| 张三 | NULL |
| zhangsan | NULL |
| zhanger | NULL |
| zer | 10 |
+----------+-------+
10 rows in set
以zhang开头的
select author from tcount_tbl where author regexp '^zhang';
+----------+
| author |
+----------+
| zhangsan |
| zhanger |
+----------+
2 rows in set
以er结尾的
select author from tcount_tbl where author regexp 'er$';
+---------+
| author |
+---------+
| zhanger |
| zer |
+---------+
2 rows in set
包含z的
select author from tcount_tbl where author regexp 'z';
+----------+
| author |
+----------+
| z |
| zhangsan |
| zhanger |
| zer |
+----------+
4 rows in set
