Skip to main content

IS NULL & IS NOT NULL

Learn IS NULL & IS NOT NULL (Operators, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction NULL means "unknown or missing", not zero and not an empty string. Because any comparison with NULL is unknown, you test for it with IS NULL and IS NOT NULL . MySQL also offers ISNULL(x) and the NULL-safe operator <=> .

More lessons in Operators