Generate SQL Queries
to help move your
WordPress Site

Need to move your WordPress site from one host to another? Perhaps you just need to update all your URLs to https for better Search Engine Optimisation?

Generate SQL Queries

UPDATE wp_options SET option_value = REPLACE(option_value, 'http://old.url.com', 'https://new.url.com');
UPDATE wp_posts SET post_content = REPLACE (post_content, 'http://old.url.com', 'https://new.url.com');
UPDATE wp_posts SET post_excerpt = REPLACE (post_excerpt, 'http://old.url.com', 'https://new.url.com');
UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, 'http://old.url.com','https://new.url.com');
UPDATE wp_termmeta SET meta_value = REPLACE (meta_value, 'http://old.url.com','https://new.url.com');
UPDATE wp_comments SET comment_content = REPLACE (comment_content, 'http://old.url.com', 'https://new.url.com');
UPDATE wp_comments SET comment_author_url = REPLACE (comment_author_url, 'http://old.url.com','https://new.url.com');
UPDATE wp_usermeta SET meta_value = replace(meta_value, 'http://old.url.com','https://new.url.com');
UPDATE wp_links SET link_url = replace(link_url, 'http://old.url.com','https://new.url.com');
UPDATE wp_posts SET guid = REPLACE (guid, 'http://old.url.com', 'https://new.url.com') WHERE post_type = 'attachment';
have a project
for us?

Contact us below and we’ll meet to learn more about your business and how we can work together.