Select Page

How to search and replace in MySql

The code below will do the trick, this line can be modified to accomodate your needs. A where clause can also be added

UPDATE databaseTableName SET tableColumnName = replace(tableColumnName,"findValue","replaceValue");

Last Updated On March 23, 2018

Leave a reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.