NULL = NULL

Question

NULL = NULL

Accepted Answer

In SQL, NULL represents an unknown value. Comparing two unknowns produces another unknown, not true. This is why WHERE col = NULL never matches any rows - you must use IS NULL instead. This three-valued logic (true, false, null) is one of the most common sources of bugs in SQL.