Skip to content

Instantly share code, notes, and snippets.

@DioVayne

DioVayne/sql.mysql

Last active October 5, 2017 04:32
Show Gist options
  • Save DioVayne/1374489f9c81e388a8baeb639f6430c7 to your computer and use it in GitHub Desktop.
Save DioVayne/1374489f9c81e388a8baeb639f6430c7 to your computer and use it in GitHub Desktop.
Download ZIP
find and replace in mysq database
Raw
sql.mysql
UPDATE `Kolom` k
LEFT JOIN `Rij` r ON k.rowId = r.rowId
SET `columnText` = replace(columnText, '140-142', '140')
WHERE INSTR(columnText, '140-142') > 0 AND r.siteId = 23;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment