From: Gary Josack [mailto:gary@stripped]
Sent: Saturday, September 22, 2007 2:47 PM
To: Stephen Sunderlin
Subject: Re: Finding empty feilds
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.
> -----Original Message-----
> From: Gary Josack [mailto:gary@stripped]
> Sent: Saturday, September 22, 2007 1:20 PM
> To: Stephen Sunderlin
> Cc: mysql@stripped
> 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?
> have you tried:
> WHERE field IS NULL?
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql