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";

Home   Our knowledge base   Sitemap   Contact           Terms of Service   Privacy Policy   Usage Policy           © 2002-2013, All rights reserved, Atlantic Silicon Inc.