I'm trying to find a null value anywhere in QA table. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 04, 2004 9:46 AM To: Scott Hamm Cc: [EMAIL PROTECTED] Subject: Re: Looking for null values.
Are you just looking for any column is null or that all columns are null or that specific columns are null or ..... what exactly do you need to determine? Shawn Green Database Administrator Unimin Corporation - Spruce Pine Scott Hamm <[EMAIL PROTECTED]> wrote on 10/02/2004 11:21:58 AM: > 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] >
