-
基本用法
select * from user where user_id in (600,601,602);
-
多个字段同时使用
select * from user where (user_id,type) in ((568,6),(569,6),(600,8));
-
多表同时多个字段使用
select * from user where (legal_id,type) not in (select a.legal_id,a.type from user as a , role_user_relation as b where a.legal_id=b.legal_id and a.type=b.legal_type) limit 0,10;
作者:关小白plus
来源:CSDN
原文:https://blog.csdn.net/Guanjs2016/article/details/80237490
版权声明:本文为博主原创文章,转载请附上博文链接!