仅作记录，不建议使用。

运行以下代码即可：

前一个地址是要替换的旧地址

后一个地址是新地址

#替换文章
update wp_posts set post_content=replace(post_content,'https://n3m.org','https://n3m.org');
update wp_posts set post_content=replace(post_content,'https://n3m.org','https://n3m.org');
update wp_posts set post_content=replace(post_content,'https://n3m.org','https://n3m.org');
update wp_posts set post_content=replace(post_content,'https://n3m.org','https://n3m.org');
update wp_posts set post_content=replace(post_content,'https://n3m.org','https://n3m.org');
update wp_posts set post_content=replace(post_content,'https://n3m.org','https://n3m.org');
#替换评论
update wp_comments set comment_content=replace(comment_content,'https://n3m.org','https://n3m.org');
update wp_comments set comment_content=replace(comment_content,'https://n3m.org','https://n3m.org');
update wp_comments set comment_content=replace(comment_content,'https://n3m.org','https://n3m.org');
update wp_comments set comment_content=replace(comment_content,'https://n3m.org','https://n3m.org');
update wp_comments set comment_content=replace(comment_content,'https://n3m.org','https://n3m.org');
update wp_comments set comment_content=replace(comment_content,'https://n3m.org','https://n3m.org');
#替换评论URL
update wp_comments set comment_author_url=replace(comment_author_url,'https://n3m.org','https://n3m.org');
update wp_comments set comment_author_url=replace(comment_author_url,'https://n3m.org','https://n3m.org');
update wp_comments set comment_author_url=replace(comment_author_url,'https://n3m.org','https://n3m.org');
update wp_comments set comment_author_url=replace(comment_author_url,'https://n3m.org','https://n3m.org');
update wp_comments set comment_author_url=replace(comment_author_url,'https://n3m.org','https://n3m.org');
update wp_comments set comment_author_url=replace(comment_author_url,'https://n3m.org','https://n3m.org');
#替换旧的本站友链
update wp_links set link_url=replace(link_url,'https://n3m.org','https://n3m.org');
update wp_links set link_url=replace(link_url,'https://n3m.org','https://n3m.org');
update wp_links set link_url=replace(link_url,'https://n3m.org','https://n3m.org');
update wp_links set link_url=replace(link_url,'https://n3m.org','https://n3m.org');
update wp_links set link_url=replace(link_url,'https://n3m.org','https://n3m.org');
update wp_links set link_url=replace(link_url,'https://n3m.org','https://n3m.org');