# WordPress 换域名代码

- Link: https://www.ixiqin.com/2018/08/16/wordpress-in-domain-code/
- Published: 2018-08-16T09:49:16+08:00
- Author: 白宦成

```language-sql
    UPDATE wp_options SET option_value = replace(option_value, 'www.olddomain.com','www.newdomain.com') ;
    UPDATE wp_posts SET post_content = replace(post_content, 'www.olddomain.com','www.newdomain.com') ;
    UPDATE wp_comments SET comment_content = replace(comment_content, 'www.olddomain.com', 'www.newdomain.com') ;
     UPDATE wp_comments SET comment_author_url = replace(comment_author_url, 'www.olddomain.com', 'www.newdomain.com') ;
    ```