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]
RE: Looking for null values.
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]
RE: Looking for null values.
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]
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]
RE: Looking for null values.
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]
