How to use find replace in MYSQL

[Andrew]

If, like us you have lots of data in your mysql database and need to make a find/replace change (like in excel) you can!

So, for example, let’s say you have a table called “mytable” with data stored in a field called “mycontent” and you want to replace all instances of the word “one” with “two”, then your SQL would look like this:

Code:

update mytable set mycontent = replace(mycontent,'one','two');