update tablename set field = replace(field,'search_for_this','replace_with_this');
View the discussion thread.