update table_name set table_field = replace(table_field,'replace_that','with_this');
update posts set content = replace(content,'dog','cat');