mysql:select * from a where a.id in(✀1✀,✀2✀,✀3✀) and a.name IS NOT NULL and a.pp=✀000✀

2025-05-20 14:18:40
推荐回答(1个)
回答1:

select * from a where ( (a.id in('1','3') and a.name IS NOT NULL or ( a.id = '2' ) ) and a.pp='000'