批量替换帖子内容
1 | UPDATE pre_forum_post SET message=REPLACE(message,'替换前词语','替换后词语') |
批量替换标题
1 | UPDATE pre_forum_thread SET subject = REPLACE(subject , ‘替换前词语’ , ‘替换后词语’) ; |
1 | UPDATE pre_forum_post SET subject = REPLACE(subject,’替换前词语’,’替换后词语’) |
批量替换帖子内容
1 | UPDATE pre_forum_post SET message=REPLACE(message,'替换前词语','替换后词语') |
批量替换标题
1 | UPDATE pre_forum_thread SET subject = REPLACE(subject , ‘替换前词语’ , ‘替换后词语’) ; |
1 | UPDATE pre_forum_post SET subject = REPLACE(subject,’替换前词语’,’替换后词语’) |
本作品采用知识共享署名 3.0 许可协议进行许可。转载或基于此篇文章继续创作或修改引用请注明出处Super Mouse!
[标题:Discuz X3.2批量替换论坛标题和内容关键词 ]
[引用链接:https://blog.lsza.net/archives/466.html]