sql=select * from sjjbxx sj where sj.sflx<>s
用这个语句:select * from sjjbxx sj where instr(concat(sj.sflx,'xx'),'s') = 0
我一般都这么写 select * from sjjbxx sj where sj.sflx != s
s是字符串吗?是的话加上'' 单引号