Sql语句批量删除Discuz帖子的方法

seeker908

Discuz的帖子表结构比较多，比较复杂，所以删帖之前请先备份数据

1. DELETE FROM `pre_forum_thread` WHERE  fid = 123 and dateline < 1546358400 ;
   
2. DELETE FROM `pre_forum_post` WHERE  fid = 123 and dateline < 1546358400 ;

复制代码

注：时间戳可以从这里转换 https://tool.chinaz.com/Tools/unixtime.aspx



批量屏蔽语句：

1. UPDATE pre_forum_post  set status =1 where `subject` LIKE '%游戏%' and `first` = 1

复制代码