模糊查询
模糊查询
格式:
where 字段名 like "通配符"
_匹配单个字符
%匹配0-N个字符
mysql> select name from user where name like "%a%"; 列出name中的值有a的记录,%匹配0-N个字符
mysql> select name from user where name like "a%"; 列出name中的值以"a开头"的记录
mysql> select name from user where name like "%a"; 列出name中的值以"a结尾"的记录
mysql> select name from user where name like "a%a"; 列出name中的值以"a开头也以a结尾"的记录
mysql> select name from user where name like "___"; 名字中只有3个字符,_匹配单个字符
mysql> select name from user where name like "_a_"; 名字中只有3个字符,并且中间的字符是a
mysql> select name from user where name like "_%_"; 名字至少3个字符,_匹配单个字符,%匹配0-N个字符
+---------------------+
| name |
+---------------------+
| root |
| bin |
| daemon |
... ...
mysql> select name from user where name like "__%__"; 名字至少4个字符
+---------------------+
| name |
+---------------------+
| root |
| daemon |
... ...