I think you would have to do one column at a time. Like this.
Select * from QA where title is NULL; Or you could get a little more crazy with something like this. Select * from QA where (title is NULL) or (blabla is NULL) or (jimbob is NULL) or (theskyisfall is NULL); Donnny > -----Original Message----- > From: Scott Hamm [mailto:[EMAIL PROTECTED] > Sent: Saturday, October 02, 2004 10:22 AM > To: [EMAIL PROTECTED] > Subject: Looking for null values. > > How do I use SQL to look for null values in ANY column? > > SELECT * FROM QA WHERE * = null; > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
