For some reason I can never remember how to search for database table fields that are either
NOT NULL. I always try to use the
= operator or something else.
So, for myself, here’s an example of how to perform a SQL query and find all records where a field in a database table is
SELECT * FROM foo WHERE bar IS NULL;
And here’s how to perform a SQL query showing all records in a database table where a column is
SELECT * FROM foo WHERE bar IS NOT NULL;
This is standard SQL, and works with every database I’ve tried, including MySQL, Oracle, Postgres, and SQL Server.
help support my writing
& keep this website running