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 <=> ”;
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 <=> ”;