当前位置：Super Mouse > Discuz > 正文

Discuz X3.2批量替换论坛标题和内容关键词

2017-02-17 分类：Discuz 阅读(776) 评论(0)

批量替换帖子内容

UPDATE pre_forum_post SET message=REPLACE(message,'替换前词语','替换后词语')

1	UPDATE pre_forum_post SET message=REPLACE(message,'替换前词语','替换后词语')

批量替换标题

UPDATE pre_forum_thread  SET subject = REPLACE(subject , ‘替换前词语’ , ‘替换后词语’) ;

1	UPDATE pre_forum_thread SET subject = REPLACE(subject , ‘替换前词语’ , ‘替换后词语’) ;

UPDATE pre_forum_post SET subject = REPLACE(subject,’替换前词语’,’替换后词语’)

1	UPDATE pre_forum_post SET subject = REPLACE(subject,’替换前词语’,’替换后词语’)

转载或引用请注明出处： Super Mouse

[标题：Discuz X3.2批量替换论坛标题和内容关键词引用链接：https://blog.lsza.net/archives/466.html]

中国金鱼