Skip to content

Instantly share code, notes, and snippets.

@clintonhalpin

clintonhalpin/SnippetFile

Created July 18, 2012 22:44
Show Gist options
  • Save clintonhalpin/3139462 to your computer and use it in GitHub Desktop.
Save clintonhalpin/3139462 to your computer and use it in GitHub Desktop.
Download ZIP
Search and Replace DB
Raw
SnippetFile
update sample_table_name set data = replace(data, ‘jpg ’, ‘jpg’)
--
update {table_name} set {column} = replace({column}, ‘{text to replace}’, ‘{replace with}’)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment