MySQL Query to check at least one field is greater than zero I want to retrieve the row if any of the 3 integer field in a row is greater than zero. All the field has default value of zero.

Which of the following query is better?

-- Query 1
SELECT * FROM my_table WHERE number_A &gt; 0 OR number_B &gt; 0 OR number_C &gt; 0

-- Query 2
SELECT * FROM my_table WHERE (number_A + number_B + number_C) &gt; 0


While checking the execution time both the query gives same numbers and the result data of the query is exactly the same.
In addition to the other differences between the two statements

WHERE (number_A + number_B + number_C) &gt; 0


Could cause you problems if any of those three are negative. That may not be relevant in your case, but if one of these is negative the total might fail to exceed zero even if another of the values does exceed zero.