Surf 11 » SELECT NULL Rows with MySQL
Finding the best waves on the web.
November 21, 2006
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
- Free MySQL and PostgreSQL Hosting Accounts
- MySQL vs Oracle vs PostgreSQL
- How To Check if MySQL Query Caching is Turned On
- MySQL Optimization Hints
- How to Version HTML5 Database openDatabase()
- MySQL - SQL To Add a Column to a Table
- Maatkit: A toolkit that provides advanced functionality for MySQL
- My MySQL Backup Script
- Getting Started - Making AJAX Applications Crawlable - Google Code
- Our Collectors : Jon Masamitsu's Weblog
- Ponemon Cost of a Data Breach
- jsPerf: JavaScript performance playground
- Updating OpenSSH over SSH with yum CentOS
- betali.st
- How to Version HTML5 Database openDatabase()
- Mac USB File Copy - Unexpected Error Occurred
Subscribe to our RSS Feed: 
XML
XML