Tag: mysql
-
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’)
-
Update Mysql table
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.