Skip to content

Instantly share code, notes, and snippets.

@matthewsimo

matthewsimo/gist:3422501

Created August 22, 2012 05:28
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save matthewsimo/3422501 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save matthewsimo/3422501 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Query to find 'search-term-find' & replace with 'search-term-replace' in a colX in tableX if colY matches colYvalue in same row.
Raw
gistfile1.sql
UPDATE tableX
SET tableX.`colX` = REPLACE(colX,'search-term-find','search-term-replace')
WHERE tableX.`colY` = 'colYvalue';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment