Skip to content

Instantly share code, notes, and snippets.

@alvinnguyen

alvinnguyen/mysql_replace.sql

Created September 9, 2016 00:44
Show Gist options
  • Save alvinnguyen/2f373a3dc91613e2cb81d9e8130e4624 to your computer and use it in GitHub Desktop.
Save alvinnguyen/2f373a3dc91613e2cb81d9e8130e4624 to your computer and use it in GitHub Desktop.
Download ZIP
How to replace value in mysql query
Raw
mysql_replace.sql
update core_config_data
set value = replace(value, 'intl.forever', 'oscarintl.forever')
where value like '%intl.forevernew%'; -- this is so the query doesn't spend time checking all other rows
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment