search & replace string in mysql

search & replace string in mysql:

To find & replace string in mysql use "update" as,

update tablename set fieldname = replace(fieldname,'search string','replace with')

Example:

update test set description = replace(description,'”','"')

update clipart set description = replace(description,'”','"')