Skip to content

Instantly share code, notes, and snippets.

@SuN-80

SuN-80/search-replace.sql

Created February 20, 2018 12:43
Show Gist options
  • Save SuN-80/4113eafdbf9861cc7285c1e17c261ee6 to your computer and use it in GitHub Desktop.
Save SuN-80/4113eafdbf9861cc7285c1e17c261ee6 to your computer and use it in GitHub Desktop.
Download ZIP
Search/Replace All occurrences in MySQL
Raw
search-replace.sql
UPDATE mytable SET field = replace(field, 'search_for', 'replace_with');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment