1. 删除待审核批评,垃圾批评,采取站批评delete
From ‘wp_comments’
WHERE ‘cooment_approved’ NOT LIKE ‘1’
2. 只删除待审批评delete
From ‘wp_comments’
WHERE ‘cooment_approved’ =‘0’
3. 只删除垃圾批评delete
From ‘wp_comments’
WHERE ‘cooment_approved’=’spam’
4只删除采取站批评delete
From ‘wp_comments’
WHERE ‘cooment_approved’=’trash’