wordpress搬家换站换域名就得来一遍这个。。

UPDATE wp_options SET option_value = replace(option_value,'old','new');

UPDATE wp_posts SET guid = REPLACE(guid,'old','new');

UPDATE wp_posts SET post_content = REPLACE(post_content,'old','new');