IS NULL vs = NULL

Question

IS NULL vs = NULL

Accepted Answer

In SQL, NULL represents an unknown value, so NULL = NULL is NULL (unknown), not TRUE. The WHERE clause only keeps rows where the condition evaluates to TRUE, so NULL conditions are treated like FALSE and filtered out. IS NULL is a special operator designed specifically to check for the absence of a value - it returns TRUE when the value is NULL.