Monthly Archives: November 2012

  • IT

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_name set column_name = replace(column_name, ‘old-text’, ‘new-text’)

Read more
Back to top