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]
