MySQL SQL

MySQL NULL Values

Understand missing or unknown values in MySQL.

Test for NULL

SELECT * FROM products
WHERE discount IS NULL;

Do not use = NULL. Use IS NULL or IS NOT NULL because NULL is not equal to any value.