zblog帖子内容域名批量替换mysql数据库语句:
UPDATE zbp_post SET log_Content = replace( log_Content, '老域名','新域名')
discuz帖子内容页mysql批量替换语句:
UPDATE pre_forum_post SET message = replace( message, '老域名','新域名')
wordpress使用mysql批量修改文章外链的语句:
UPDATE wp_posts SET post_content = REPLACE( post_content, '老域名', '新域名' )
discuz更新邮件激活状态
update pre_common_member set emailstatus = 1