eivko/replace.sql

Created August 3, 2017 14:19

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/eivko/a7b552b931e89b7884e44752e7bf1fb5.js"></script>
Save eivko/a7b552b931e89b7884e44752e7bf1fb5 to your computer and use it in GitHub Desktop.

Download ZIP

найти и заменить часть содержимого таблицы

Raw

replace.sql

UPDATE articles SET text = REPLACE(text, '8-927-123-45-67', '8-927-123-76-54') WHERE text LIKE '%8-927-123-45-67%'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment