Skip to content

Instantly share code, notes, and snippets.

@yoavmatchulsky

yoavmatchulsky/wp-non-ssl-to-ssl.sql

Last active August 29, 2016 09:49
Show Gist options
  • Save yoavmatchulsky/fadcda0e5996171e56788b7928f9e0e6 to your computer and use it in GitHub Desktop.
Save yoavmatchulsky/fadcda0e5996171e56788b7928f9e0e6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
wp-non-ssl-to-ssl.sql
-- Change all http:// references to https://
UPDATE wp_posts SET post_content=REPLACE(post_content, 'http://', 'https://');
-- Change site's url and homepage
UPDATE wp_options SET option_value=REPLACE(option_value, 'http://', 'https://') WHERE option_name IN ('siteurl', 'home');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment