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]