Thanks!
-Original Message-
From: Gary Josack [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 22, 2007 2:47 PM
To: Stephen Sunderlin
Cc: mysql@lists.mysql.com
Subject: Re: Finding empty feilds
NULL does not equal "", " ", "null", "0", 0 or an
ng 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: Findi
@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'
> F
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 f