WP wordpress 搬家域名批量替换的方法

UPDATE wp_options SET option_value = REPLACE(option_value,’旧域名’,’新域名’);

UPDATE wp_posts SET post_content = replace(post_content,’旧域名’,’新域名’);

UPDATE wp_posts SET post_excerpt= replace(post_excerpt,’旧域名’,’新域名’);

UPDATE wp_posts SET guid= replace(guid, ‘旧域名’,’新域名’);