Created
February 5, 2019 13:54
-
-
Save mrkkr/750dd18a460fdb3b4830312699e3c960 to your computer and use it in GitHub Desktop.
Wordpress - Update all old URLs in database with SQL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UPDATE wp_options SET option_value = replace(option_value, 'OLD URL', 'NEW URL') WHERE option_name = 'home' OR option_name = 'siteurl'; | |
UPDATE wp_posts SET post_content = replace(post_content, 'OLD URL', 'NEW URL'); | |
UPDATE wp_postmeta SET meta_value = replace(meta_value,'OLD URL','NEW URL'); | |
UPDATE wp_usermeta SET meta_value = replace(meta_value, 'OLD URL','NEW URL'); | |
UPDATE wp_links SET link_url = replace(link_url, 'OLD URL','NEW URL'); | |
UPDATE wp_comments SET comment_content = replace(comment_content , 'OLD URL','NEW URL'); | |
UPDATE wp_posts SET post_content = replace(post_content, 'OLD URL', 'NEW URL'); | |
UPDATE wp_links SET link_image = replace(link_image, 'OLD URL','NEW URL'); | |
UPDATE wp_posts SET guid = replace(guid, 'OLD URL','NEW URL'); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment