Testing NULLs
suggest changeIS NULL/IS NOT NULL–= NULLdoes not work like you expect.x <=> yis a “null-safe” comparison.
In a LEFT JOIN tests for rows of a for which there is not a corresponding row in b.
SELECT ...
FROM a
LEFT JOIN b ON ...
WHERE b.id IS NULL
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents