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

_{from MySQL Search and Replace | Urban Mainframe}