UPDATE typecho_contents SET text = REPLACE(text,'旧域名地址','新域名地址');
UPDATE typecho_users SET text = REPLACE(text,'旧域名地址','新域名地址');
注意:在phpmyadmin中运行sql命令时,http 不能输入,只能是域名的名称字母。
UPDATE typecho_contents SET text = REPLACE(text,'wp.cyoy.cn','cyoy.cn');
下面这条就不行:
update typecho_contents set text = replace(text,'https://wp.cyoy.cn/','http://9nas.cn:7000/');
参考:
https://www.zctou.com/2047.html
http://www.liangxin.name/?post=578
https://cloud.tencent.com/developer/article/1340502