正则表达式

正则表达式

格式：
where 字段名 regexp ‘正则表达式’
正则匹配 ^ $ . * [ ] |

mysql> select name from user
-> where
-> name regexp '^a|^t'; regexp中文意思是正则表达式。列出name值“以a开头或以t结尾”的记录

mysql> select name,uid from user where uid regexp '....'; .代表1个字符，列出uid中包含(4个字符及以上)的记录
+-----------+-------+
| name | uid |
+-----------+-------+
| nfsnobody | 65534 |
| lisi | 1000 |
| bob | 3001 |
+-----------+-------+

mysql> select name,uid from user where uid regexp '^....$'; uid只能是4个字符,^代表开头,$代表结尾
+------+------+
| name | uid |
+------+------+
| lisi | 1000 |
| bob | 3001 |
+------+------+

mysql> select name,uid from user where name regexp '^r.*t$'; r开头t结尾， .* 是(.单个字符)匹配(*任意次数)
+-------+------+
| name | uid |
+-------+------+
| root | 0 |
| rtkit | 172 |
+-------+------+

mysql> select name,uid from user where name regexp '^b.*b$';
+------+------+
| name | uid |
+------+------+
| bob | 3001 |
+------+------+