How to Find and eplace Data in MySQL To update and replace some value of a key we would need to run this command: UPDATE `pages` SET `content` = REPLACE(`content`,”wrong text”,”right text”) WHERE `id`=”1″;