The Blog

MySQL find and replace Posted on

UPDATE `table` SET `filed1` = replace(`filed1`,’xyz’,’abc’);

This will replace partial string, for example:  “My xyz friend is here” -> “My abc friend is here”

This entry was posted in MySQL. Bookmark the permalink.

Please Post Your Comments & Reviews

Your email address will not be published. Required fields are marked *

Change the CAPTCHA codeSpeak the CAPTCHA code