Skip to content

Instantly share code, notes, and snippets.

@benrothe

benrothe/FindAndReplace.sql

Last active October 5, 2015 07:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save benrothe/2769474 to your computer and use it in GitHub Desktop.
Save benrothe/2769474 to your computer and use it in GitHub Desktop.
Download ZIP
Find & replace data in MySQL
Raw
FindAndReplace.sql
UPDATE [table_name] SET [field_name] = REPLACE([field_name], '[string_to_find]', '[string_to_replace]');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment