MySQL Selecting Null

 Computers and Networking
Apr 142013
 

Show what IS NOT NULL:
SELECT *
FROM table
WHERE YourColumn IS NOT NULL;

This seems to show what IS NULL:
SELECT *
FROM table
WHERE YourColumn <=> NULL;

This seems to show what IS empty:
SELECT *
FROM table
WHERE YourColumn <=> ”;

Source