用 select * from mUser where s_id not like '%2%' 结果显示为空!
请问高人指点一下,如果写SQL语句才正确?在线等!期待解决方法!! select * from mUser where s_id not in (select s_id from mUser where s_id like '%2%') 应该在不符合记录的条件内筛选 select * from mUser where s_id not in (select s_id from mUser where s_id like '%2%') select * from mUser where s_id not like '*2*' ASSCESS跟SQL有些地方不一樣.我也是以前有寫過才知道的.
执行之后返回是空的! Access sql查询支持 not in吗? select * from mUser where s_id not in (select s_id from mUser where s_id like '%2%') 可以用了.
