WordPress更换域名/批量修改文章内容/文章标题/标签TAG

update wp_posts set post_content = replace(post_content,'kaixuan','凯旋')

update wp_posts set post_title = replace(post_title,'kaixuan','凯旋')

update wp_postmeta set meta_value = replace(meta_value,'ym51.lanzous.com','ym51.lanzoui.com')

update wp_terms set name = replace(name,'kaixuan','凯旋')

on_value = replace(option_value, 'www.oldmydomain.com','www.newdomain.com') ;
UPDATE wp_posts SET post_content = replace(post_content, 'www.oldmydomain.com','www.newdomain.com') ;
UPDATE wp_comments SET comment_content = replace(comment_content, 'www.oldmydomain.com', 'www.newdomain.com') ;
UPDATE wp_comments SET comment_author_url = replace(comment_author_url, 'oldwww.mydomain.com', 'www.newdomain.com') ;

on_value = replace(option_value, 'www.oldmydomain.com','www.newdomain.com') ;
UPDATE wp_posts SET post_content = replace(post_content, 'http://','https://') ;
UPDATE wp_comments SET comment_content = replace(comment_content, 'http://','https://') ;
UPDATE wp_comments SET comment_author_url = replace(comment_author_url, 'http://','https://') ;