How to perform a SQL query for fields that is null (or NOT NULL)

Okay, maybe this was lame, but when I ' ve been away from writing SQL database queries for a while I can never remember how T o Search for database table fields, is either null, or NOT NULL. I always try to use the = operator or something else.

So, for your Al, here's how to perform a SQL query and the Find all records where a field in a database table is NULL:

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 field was not NULL:

SELECT * from Foo WHERE bar is not NULL;

　　

This works with every database I ' ve tried, including MySQL, Oracle, Postgres, and SQL Server.

How to perform a SQL query for fields that is null (or NOT NULL)