Surf 11 » SELECT NULL Rows with MySQL

Finding the best waves on the web.

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


Related Entries
Name:

Email: (optional, not displayed on site)
   Subscribe to this thread
Comments: (html will be escaped)



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