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