discuzX2批量替换帖子内容某字段MYSQL数据库

进入后台数据库,点击MYSQL,在查询框内输入下面代码,更改要替换和被替换的字符串,执行即可,支持中英文替换:

UPDATE pre_forum_post SET message=REPLACE(message,'要替换的字符串','替换后的字符串')

Add Comment

Required fields are marked *. Your email address will not be published.