Tag Archives: mysql

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’)

This will update data in a MySQL table whether is empty or not.

UPDATE artists SET city = ‘Los Angeles’  WHERE city=’Sydney’

In this case Sydney will be replaced by Los Angeles.