按你的意图,似乎是应该查出0条记录,大概需要写成如下命令:
select number from ABC
where number IN ('1','4','6','13')
and exists( select 1 from ABC where number='1' )
and exists( select 1 from ABC where number='4' )
and exists( select 1 from ABC where number='6' )
and exists( select 1 from ABC where number='13' )
SELECT * FROM 表名 where workplace like CONCAT("%人民%","%办%") or workplace like CONCAT("%东营区%","%人民%","%办%")这样就可以了
-- 删除“才能”update db_centent set body = replace(body,'才能','')
-- 替换为“可以”
update db_centent set body = replace(body,'才能','可以')
希望能帮到你,加油!
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)