56,801
社区成员
发帖
与我相关
我的任务
分享不包含某字符串用SQL查询怎么写
我知道查询包含某字符串是
SELECT * FROM users WHERE fname LIKE '%e%'
但不包含某字符串用SQL查询怎么写
SELECT * FROM users WHERE fname LIKE '%e%'
但不包含某字符串用SQL查询怎么写
...全文
请发表友善的回复…
发表回复
redtank2005 2006-03-16
- 打赏
- 举报
谢谢了
hy2003fly 2006-03-16
- 打赏
- 举报
直接加个"not"就可以了.
mysql> use test;
Database changed
mysql> select * from tt;
+----+------+
| id | name |
+----+------+
| 1 | john |
| 2 | kety |
+----+------+
2 rows in set (0.19 sec)
mysql> select * from tt where name like "%j%";
+----+------+
| id | name |
+----+------+
| 1 | john |
+----+------+
1 row in set (0.00 sec)
mysql> select * from tt where name not like "%j%";
+----+------+
| id | name |
+----+------+
| 2 | kety |
+----+------+
1 row in set (0.00 sec)
mysql>
mysql> use test;
Database changed
mysql> select * from tt;
+----+------+
| id | name |
+----+------+
| 1 | john |
| 2 | kety |
+----+------+
2 rows in set (0.19 sec)
mysql> select * from tt where name like "%j%";
+----+------+
| id | name |
+----+------+
| 1 | john |
+----+------+
1 row in set (0.00 sec)
mysql> select * from tt where name not like "%j%";
+----+------+
| id | name |
+----+------+
| 2 | kety |
+----+------+
1 row in set (0.00 sec)
mysql>
