PHP/SQL : SELECT 2 columns 3 times with different values

Question

我想用不同的值两次选择 2 列

SELECT id FROM ads WHERE onoff='1' AND again='0'
SELECT id FROM ads WHERE onoff='2' AND again='1'
SELECT id FROM ads WHERE onoff='3' AND again='1'

有没有办法在一个 sql 中完成这一切？

Answer 1

SELECT id 
FROM ads 
WHERE (onoff = '1' AND again = '0')
   OR (onoff = '2' AND again = '1')
   OR (onoff = '3' AND again = '1')