Skip to content

Instantly share code, notes, and snippets.

@douglasmiranda

douglasmiranda/gist:3254332

Created August 4, 2012 04:05
Show Gist options
  • Save douglasmiranda/3254332 to your computer and use it in GitHub Desktop.
Save douglasmiranda/3254332 to your computer and use it in GitHub Desktop.
Download ZIP
How to Find and Replace Text in MySQL Database using SQL
Raw
gistfile1.sql
update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, "find this string", "replace found string with this string");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment