Skip to content

Instantly share code, notes, and snippets.

@yanknudtskov

yanknudtskov/Search and replace in MySQL table.mysql

Created January 4, 2014 13:24
Show Gist options
  • Save yanknudtskov/8255307 to your computer and use it in GitHub Desktop.
Save yanknudtskov/8255307 to your computer and use it in GitHub Desktop.
Download ZIP
Search and replace in MySQL table
Raw
Search and replace in MySQL table.mysql
update table_name set field_name = replace(field, 'search_string', 'replace_string') where instr(field_name, 'search_string') > 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment