例如:表里有 "张龙","赵虎","王朝","马汗","张三","李四","王二";
我想要的结果是查出除过"张龙"以及"赵虎"之外所有匹配的值
等于就是select * from where name in("王朝","马汗","张三","李四","王二");但是数据太多,需要排除来查,现在想通过"张龙"和"赵虎"来反向查,能行吗?
我想要的结果是查出除过"张龙"以及"赵虎"之外所有匹配的值
等于就是select * from where name in("王朝","马汗","张三","李四","王二");但是数据太多,需要排除来查,现在想通过"张龙"和"赵虎"来反向查,能行吗?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货