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.
MySQL SQL
Understand missing or unknown values in MySQL.
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.