Your old URLs will eventually be replaced by your newly chosen ones. UPDATE wp_comments SET comment_content = replace(comment_content, 'Existing URL','New URL') Ĭhanging the URLs of images and posts in your website requires the use of the following codes:įor images in a single post: UPDATE wp_posts SET post_content = replace(post_content, 'Existing URL', 'New URL') įor attached images in a post: UPDATE wp_posts SET guid = replace(guid, 'Existing URL','New URL') įor images with old link manager: UPDATE wp_links SET link_image = replace(link_image, 'Existing URL','New URL') įinally, after using the correct SQL command in the SQL window, ensure that you click on “GO” in order to begin the process. UPDATE wp_links SET link_url = replace(link_url, 'Existing URL','New URL') UPDATE wp_usermeta SET meta_value = replace(meta_value, 'Existing URL','New URL') UPDATE wp_postmeta SET meta_value = replace(meta_value,'Existing URL','New URL') UPDATE wp_posts SET post_content = replace(post_content, 'Existing URL', 'New URL') UPDATE wp_options SET option_value = replace(option_value, 'Existing URL', 'New URL') WHERE option_name = 'home' OR option_name = 'siteurl'
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |