批量替换帖子内容
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,’替换前词语’,’替换后词语’) |