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 '') ;"
1
0
0
Try this
SELECT * FROM TABLE WHERE (`a` '0' or `a` = '' or `a` is null)
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
