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 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]