MySQL Null Values

MySQL NULL Values

A field with a NULL value is a field with no value.

It is not possible to test for NULL values with comparison operators, such as =, <, or <>.

We will have to use the IS NULL and IS NOT NULL operators instead.

SELECT * FROM Customers WHERE Address IS NULL;