Skip to content

Instantly share code, notes, and snippets.

@marcometz

marcometz/sql url replacement

Last active June 10, 2020 07:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save marcometz/145f095ddaefd3e8e360167bdc048f02 to your computer and use it in GitHub Desktop.
Save marcometz/145f095ddaefd3e8e360167bdc048f02 to your computer and use it in GitHub Desktop.
Download ZIP
sql replace url to localhost
Raw
sql url replacement
# www.quirinprivatbank.de => localhost:3000
UPDATE goldencobra_article_urls SET url = REPLACE(url, "https://www.quirinprivatbank.de", "http://localhost:3000");
# www.quirinprivatbank.de => staging.quirincloud.dev-ikusei.de
UPDATE goldencobra_article_urls SET url = REPLACE(url, "https://www.quirinprivatbank.de", "https://staging.quirincloud.dev-ikusei.de");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment