Month: November 2012
-
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’)