php - Mysql - select multiple columns with same value and other colums equal to zero

Question

I have a mysql query that selects the records where col1 and col2 = 4 and col3 or col4 = 0

SELECT * FROM table WHERE 4 IN(col1, col2) && (col3 = 0 || col4 = 0)

The or is not working. It returns zero rows and I know that there are 4

Answer 1

&& and || in SQL are AND and OR.

Rewrite that to:

SELECT * FROM table WHERE (col1 = 4 AND col2 = 4) AND (col3 = 0 OR col4 = 0)

You can't use IN for column names. You can use IN like this: WHERE col3 IN('4','a','another valid value'), which is equals to WHERE (col3 = '4' OR col3 = 'a' OR ...)