I think what will work for your case is the CONCAT() function
(http://dev.mysql.com/doc/mysql/en/String_functions.html). It will return
NULL if any field in it is null.
SELECT *
FROM qa
WHERE concat(field1, field2, field3,..., fieldn) is null
It won't break any speed records but it will find each record where any of
the fields {field1...fieldn} is null.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Scott Hamm <[EMAIL PROTECTED]> wrote on 10/04/2004 09:52:37 AM:
> 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]
> >
>
>
