Replace text in mysql table
Sometimes you need to replace some text in your Mysql database. Whatever it is (a user ID or a user name), this is the SQL query you need to run:
UPDATE `table` SET `field` = REPLACE(`field`, ‘string’, ‘anothervalue’)
… Read more