discuz 中批量替换帖子中的字符串(update replace)

update pre_forum_post set message=replace(message,'http://moneyslow.com','https://moneyslow.com') where message like '%http:%';

update pre_forum_thread set subject=replace(subject,'aaaaa','bbbbbb') where subject like '%aaaaa%';