直接加个"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>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货