NULL

Applies to: sql

NULL represents missing or unknown data, and it is not equal to anything (even another NULL). Test it with IS NULL / IS NOT NULL, never = NULL. NULLs also appear for unmatched rows in a LEFT JOIN.

SELECT * FROM users WHERE email IS NULL;
COALESCE(phone, 'n/a')   -- substitute a default for NULL

See also: where, join