SELECT * FROM table WHERE YourColumn IS NOT NULL;
SELECT * FROM demo WHERE Name IS NOT NULL
SELECT * FROM contacts WHERE last_name IS NOT NULL;