Skip to content

Instantly share code, notes, and snippets.

@IlanVivanco

IlanVivanco/replace_relative_urls.sql

Last active March 16, 2021 12:56
Show Gist options
  • Save IlanVivanco/01d84de5ca9a56e76b0ae63e7970690f to your computer and use it in GitHub Desktop.
Save IlanVivanco/01d84de5ca9a56e76b0ae63e7970690f to your computer and use it in GitHub Desktop.
Download ZIP
Replace WP relative URLs images
Raw
replace_relative_urls.sql
UPDATE
wp_posts
SET
post_content = (
REPLACE(post_content, 'src="http://', 'src="//')
)
WHERE
INSTR(post_content, 'jpeg') > 0
OR INSTR(post_content, 'jpg') > 0
OR INSTR(post_content, 'gif') > 0
OR INSTR(post_content, 'png') > 0
OR INSTR(post_content, 'svg') > 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment