Skip to content

Instantly share code, notes, and snippets.

@aamsur-mkt

aamsur-mkt/replace-update-like.sql

Created October 21, 2020 08:01
Show Gist options
  • Save aamsur-mkt/43e088f40b55fa1d36a0d262f938aad5 to your computer and use it in GitHub Desktop.
Save aamsur-mkt/43e088f40b55fa1d36a0d262f938aad5 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql Query for UPDATE and REPLACE part of a string
Raw
replace-update-like.sql
update article set old_body = REPLACE(old_body, 'href="/group/kmon', 'href="https://km.pgn.co.id/group/kmon') where old_body like '%href="/group/kmon%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment