ginal 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 nul
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 nu
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 d
1 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
nal 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;
>
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]
