WHERE condition in SQL query: select `a` not equal to '0'

Question

I have:

`a` int DEFAULT '0'

From the thousands of records I have, I want to select a that do not have a value of 0 or empty.

I tried something similar.

"SELECT * FROM TABLE WHERE (`a` unequal '0' or '') ;"

Answer 1

Try this

SELECT * FROM TABLE WHERE (`a` <>'0' or `a` = '' or `a` is null)