zblog帖子内容域名批量替换mysql数据库语句:
UPDATE zbp_post SET log_Content = replace( log_Content, 'https://old.google.com','https://new.google.com')
discuz帖子内容页mysql批量替换语句:
UPDATE pre_forum_post SET message = replace( message, 'https://old.google.com', 'https://new.google.com')
discuz更新邮件激活状态
update pre_common_member set emailstatus = 1
wordpress使用mysql批量修改文章外链的语句:
UPDATE wp_posts SET guid = REPLACE( guid, 'old.google.com', '2.chuibi.gay' )
UPDATE wp_ice_download SET ice_price = REPLACE( ice_price, '2', '3' )
UPDATE wp_options SET option_value = REPLACE( option_value, 'old.google.com', 'new.google.com' )
链接中的https按情况决定带不带