UPDATE wp_posts SET post_content = replace(post_content, 'old','new');

old 就是指原先的内容或链接地址  new 就是指新的链接或地址。

UPDATE pre_forum_post SET message = replace(message, 'old','new');