Search and Replace in MySQL

Submitted by:Andery Smith

Date added:23 November, 2013

Category:MySQL

You can search and replace fields by below query in MySQL Database

Tags: search mysql , replace mysql

Code Snippet:

UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring");
 
 

Comments