Ok. Will do the crazy mode. Was thinking maybe there were a shortcut or something, apparently not. Thanks though. Will have to list so many columns...... *grin*
> -----Original Message----- > From: Donny Simonton [SMTP:[EMAIL PROTECTED] > Sent: Saturday, October 02, 2004 11:31 AM > To: 'Scott Hamm'; [EMAIL PROTECTED] > Subject: RE: Looking for null values. > > 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]