Booser Empowering your life

Search and Replace Text String in MySQL Database with phpMyAdmin

Sometime you might facing problem to replace the string or data in mysql and you have many row inside your table.  Here is the solution you can put in to SQL command line in phpmyadmin, this solution is work for mysql too.  Before begin please back all your sql 1st, in case you make any mistake.

Open phpmyadmin -> click on database -> click on table name -> click on SQL tab on top then enter the command below:

UPDATE tablename SET field = replace(field, "SearchString", "ReplaceString");

please change:
tablename
field
SearchString
ReplaceString

according your table name and field.
you can also add where Clause ( add condition for this sql statemen )

UPDATE tablename SET field = replace(field, "SearchString", "ReplaceString") WHERE field2='SomeValue';

Hope this help..

Incoming search terms:

• phpmyadmin search and replace string (6)
• phpmyadmin replace text (5)
• phpmyadmin replace string (5)
• search and replace in mysql database with phpmyadmin (3)
• phpmyadmin replace (2)
• search and replace text in phpmyadmin (2)
• replace text in phpmyadmin (2)
• phpmyadmin string find replace (1)
• phpmyadmin text replace (1)
• phpmyadmin search text in database mysql (1)