Do not write
SELECT * FROM [table_name] WHERE [column_name]=NULL;
Use "IS" for NULL!!!!
SELECT * FROM [table_name] WHERE [column_name] IS NULL;
I wasted 2hours for this...
AquaCat
Posted on
【MySQL】When using "NULL" in WHERE CLAUSE
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)