wordpress更换域名

UPDATE wp_options SET option_value=replace(option_value,’旧’,’新’);

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

UPDATE wp_comments SET comment_content=replace(comment_content,’旧’,’新’);

UPDATE wp_comments SET comment_author_url=replace(comment_author_url,’旧’,’新’);

如果还没生效在执行下面的SQL，可以解决不显示缩略图的问题

UPDATE wp_postmeta SET meta_value=replace(meta_value,’旧’,’新’);

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