PLEASE Help, Mysql question
 

I need to "empty" a field within a table.
How do I do that ? (truncet)

I can empty the table itself but there's
20 other fields I don't want to "empty"

probably not the best way... but

update <tablename>
set <fieldname> = ""

if that doesnt work, add

where 1 = 1

Could ya not drop the field from the table then re-add it?

UPDATE whatever SET field='' WHERE field !='';