Mass Delete comments using phpMyAdmin

  1. Open your hosting cpanel, then scroll down to Database Tools and select phpMyAdmin
  2. In the new page that opens select your database
  3. Scroll down the page and select table wp_comments
  4. If you want to delete all comments then just right click on wp_comments table and select empty, confirm and you’re done.
    If you want to remove NON APPROVED COMMENTS then run the following query:
  • DELETE from wp_comments WHERE comment_approved = ‘0’

If you want to remove ALL PENDING COMMENTS then run the following query:

  • DELETE from wp_comments WHERE comment_approved = ‘0’

If you want to remove ALL APPROVED COMMENTS then run the following query:

  • DELETE from wp_comments WHERE comment_approved = ‘1’

If you want to remove ALL TRASH COMMENTS then run the following query:

  • DELETE from wp_comments WHERE comment_approved = ‘trash’

If you want to remove ALL SPAM COMMENTS then run the following query:

  • DELETE from wp_comments WHERE comment_approved = ‘spam’

Note: Make sure you replace the “wp_” prefix with the prefix of the wordpress install you’re working on (prefix’s can be found in the wp_config file in you file manager or in the phpmyadmin section under the wordpress install your working on)

Share This Post