WordPress图片附件批量替换域名

UPDATE `数据表名` SET `字段名` = replace (`字段名`,'要替换的内容','替换后的内容')

UPDATE wp_posts SET post_content = replace( post_content, 'AAA.com','BBB.com') ;

UPDATE wp_comments SET comment_content = replace(comment_content, 'AAA.com', 'BBB.com') ;

UPDATE wp_comments SET comment_author_url = replace(comment_author_url, 'AAA.com', 'BBB.com') ;

UPDATE `wp_posts` SET `guid` = replace (`guid`,'http://www.inlojv.com','http://xxx.inlojv.com');

UPDATE `wp_postmeta` SET `meta_value` = replace (`meta_value`,'http://www.inlojv.com','http://xxx.inlojv.com')