如何批量替换Discuz X2.5-X3.1 帖子标题和内容(亲测)

进入phpmyadmin或者DZ后台:站长 – 数据库 – 升级

X2.5-X3.1 帖子标题批量替换的命令:

UPDATE pre_forum_thread SET subject=REPLACE(subject,’要替换的内容’,’新内容’);

X2.5-X3.1 帖子内容批量替换的命令:

UPDATE pre_forum_post SET message=REPLACE(message,’要替换的内容’,’新内容’);

发表回复