Surf 11 » Archives for November, 2006

Finding the best waves on the web.
November 21, 2006

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
Post Comment | mysql null select not null is null sql


Subscribe to our RSS Feed: subscribe to this feed XML
Archives   Tags   Contact