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 & ReviewsYour email address will not be published. Required fields are marked * Save my name, email, and website in this browser for the next time I comment.
