Skip to content

Instantly share code, notes, and snippets.

@aamsur-mkt

aamsur-mkt/update-prefix.sql

Last active September 24, 2019 04:00
Show Gist options
  • Save aamsur-mkt/09e956de188fe44c7b6d8159fb8aed10 to your computer and use it in GitHub Desktop.
Save aamsur-mkt/09e956de188fe44c7b6d8159fb8aed10 to your computer and use it in GitHub Desktop.
Download ZIP
Update prefix of a field
Raw
update-prefix.sql
UPDATE db_rumah_sakit
SET icon = REPLACE (icon, 'https://from.url.com', 'http://to.url.com')
where icon like 'https://from.url.com%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment