Skip to content

Instantly share code, notes, and snippets.

@stalmok

stalmok/sql-replace-string

Created November 12, 2012 09:38
Show Gist options
  • Save stalmok/4058384 to your computer and use it in GitHub Desktop.
Save stalmok/4058384 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL: replace string and update
Raw
sql-replace-string
// replace string and update
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