Pete Freitag Pete Freitag

SELECT NULL Rows with MySQL


Need to select NULL rows with MySQL or SQL Server, here's how:

SELECT columns FROM table WHERE column IS NULL

Or to select all rows that are not null, you can use IS NOT NULL

SELECT columns FROM table WHERE column IS NOT NULL

Like this? Follow me ↯

SELECT NULL Rows with MySQL was first published on November 21, 2006.

If you like reading about mysql, or sql then you might also like:

Post a Comment