Syntax:

update table_name set field = replace(filed_name,'find string','replace with');

Ex&le:

update test set description = replace(description,'#','$');