NULL does not equal "", " ", "null", "0", 0 or any other variation.
Those are all values. NULL is the lack of a value. IS NULL and IS NOT
NULL are operators specific for working with NULL values.
Stephen Sunderlin wrote:
I was able to delete them using the CreateDate timestamp.
For future reference what is the difference between = and is
if I may ask.
Thanks.
-----Original Message-----
From: Gary Josack [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 22, 2007 1:20 PM
To: Stephen Sunderlin
Cc: mysql@lists.mysql.com
Subject: Re: Finding empty feilds
Stephen Sunderlin wrote:
I executed an insert...select and some empty fields were inserted into a
table. I'm trying to delete these empty fields but a look up for:
FIELD = ''
FIELD = 'null'
FIELD = '0'
FIELD = '[SPACE]'
Returns nothing.
What should I be looking for to delete these empty fields?
Thanks.
have you tried:
WHERE field IS NULL?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
