/*站点url和主页地址*/
UPDATE wp_options SET option_value = REPLACE(option_value, 'old.com', 'new.com') WHERE option_name = 'home' OR option_name = 'siteurl'; 
/*网站内链接及附件的地址*/
UPDATE wp_posts SET post_content = REPLACE(post_content, 'old.com', 'new.com'); 
UPDATE wp_posts SET guid = REPLACE(guid, 'old.com', 'new.com');
/*作者的评论链接*/
UPDATE wp_comments SET comment_author_url = REPLACE( comment_author_url, 'old.com', 'new.com' ); 
/*评论内链接*/
UPDATE wp_comments SET comment_content = REPLACE( comment_content, 'old.com', 'new.com' ); 
/*TrackBack里的链接*/
UPDATE wp_posts SET pinged = REPLACE( pinged, 'old.com', 'new.com' );