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.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to