How to search and replace in MySql

No Comments

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");

Image Credits: Photo by Isis França on Unsplash.

Last Updated On March 23, 2018

Related Articles

No results found

Leave a Reply

avatar
  Subscribe  
Notify of
Menu
Copy link