search and replace in a MySQL Database

update posts set content = replace(content,'dog','cat');

from MySQL Search and Replace | Urban Mainframe