Question

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

现在想修改如下：id是2的，不需要判断a.name IS NOT NULL了，1和3还是需要判断的。

Answer 1

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