The Blog of Gordon Milcham

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

    continue reading

  • 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.

    continue reading