PLEASE Help, Mysql question

[jeroman]

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"

[DrGuile]

probably not the best way... but

update <tablename>
set <fieldname> = ""

if that doesnt work, add

where 1 = 1

[Stud Money]

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

[Babaganoosh]

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