discuz批量替换字符的sql语句

UPDATE pre_forum_post SET message=REPLACE(message,'要替换的字符串','替换后的字符串');
UPDATE pre_forum_thread SET subject=REPLACE(subject,'脚本学堂','www.jb200.com');