SQL NULL needs a different predicate

In SQL, column = NULL does not test for a missing value: the comparison evaluates to unknown. Use IS NULL or IS NOT NULL. A WHERE clause keeps rows where its condition is true, so unknown comparisons do not pass.