Typecho批量替换文章内链接与图片链接

最近几天本站一直被人打，于是我就想到了OSS没设置带宽封顶策略，于是开启缓存后OSS域名变更了，文章链接图片附件链接等全部失效，虽然网上有替换插件，但是没有改变数据库内容总感觉没从根本上解决问题，于是就利用SQL语句替换掉了域名，又可以访问了。开心 <img src="https://image.blogbig.cn/handsome/assets/img/emotion/aru/cheer.png" class="emotion-aru">

## 事列

如OSS原域名：`blog-196.cos.ap-guangzhou.myqcloud.com`
现在的域名：`image.blogbig.cn`

则旧网址：`blog-196.cos.ap-guangzhou.myqcloud.com`
新网址：`image.blogbig.cn`

## 进入文章数据表

进入typecho_contents表（文章内容表）
![表](https://image.blogbig.cn/2020/06/16/1592303572.png)

## SQL语句

点击“SQL”输入下面的语句，点击“执行”

````````````````````````````````````````````````````````````````````````````````
UPDATE `typecho_contents` SET `text` = REPLACE(`text`,'旧网址','新网址');
````````````````````````````````````````````````````````````````````````````````

![SQL](https://image.blogbig.cn/2020/06/16/1592303792.png)

## 同样替换typecho_fields表（文章字段表）

点击“SQL”输入下面的语句，点击“执行”。

````````````````````````````````````````````````````````````````````````````````````````
UPDATE `typecho_fields` SET `str_value` = REPLACE(`str_value`,'旧网址','新网址');
````````````````````````````````````````````````````````````````````````````````````````

## 后言

替换还有很多用处，比如当网址配置SSL后需要更改链接。
则旧网址：`http://域名`
新网址：`https://域名`

其他系统替换大同小异，只需要改一下语句里的表名就ok啦。

正文到此结束