sql - WHERE all IS NOT NULL

Question

How can I run a MySQL query that selects everything that is not null? It would be something like

SELECT * FROM schedule WHERE ((all)) IS NOT NULL

Do I just remove the all and go..?

SELECT * FROM schedule WHERE IS NOT NULL

Answer 1

You'll have to explicitly state the condition on each column, so e.g.

SELECT *
FROM schedule 
WHERE id IS NOT NULL
  AND foo IS NOT NULL
  AND bar IS NOT NULL; -- and so on..