Check if the column is null in mysql

If you want to check whether a column is null, you should use IS NULL, not = NULL.

NG

WHERE column = NULL

OK

WHERE column IS NULL

reference