Skip to content

Instantly share code, notes, and snippets.

@ThijsFeryn

ThijsFeryn/update_find_and_replace_by_last_occurrence.sql

Last active June 9, 2016 10:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ThijsFeryn/649447302a88acd1f3844d3fb4773701 to your computer and use it in GitHub Desktop.
Save ThijsFeryn/649447302a88acd1f3844d3fb4773701 to your computer and use it in GitHub Desktop.
Download ZIP
Update statement that does a find and replace based on the last occurrence of a string
Raw
update_find_and_replace_by_last_occurrence.sql
UPDATE `table` SET `somefield` = CONCAT(TRIM(TRAILING 'feryn.eu' FROM `name`),'thijs.be') WHERE 'otherField' = 'value'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment