Thanks!
-----Original Message-----
From: Gary Josack [mailto:gary@stripped]
Sent: Saturday, September 22, 2007 2:47 PM
To: Stephen Sunderlin
Cc: mysql@stripped
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.
>
> Thanks.
>
>
> -----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?
>>
>> 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/mysql?unsub=1
