NULL is not a value but an unknown, so NULL = NULL is not true (it is NULL). Use IS NULL, and remember that comparisons with NULL make WHERE drop the row.
NULL
The SQL marker for an unknown or missing value.
NULL is not a value but an unknown, so NULL = NULL is not true (it is NULL). Use IS NULL, and remember that comparisons with NULL make WHERE drop the row.