mysql find and replace

Question

I'm trying to replace a bunch of no UTF-8 characters

ie/ ’

Here's my query:

SELECT * FROM `tbl_act` WHERE `actDesc` LIKE '%’%' -

How can I form this to 'Find And Replace' with the characters: "\'" ???

Answer 1

update [table_name] 
set [field_name]=replace([field_name],'[string_to_find]','[string_to_replace]');

Referred from http://www.mediacollege.com/computer/database/mysql/find-replace.html