Blog Building 101

How to make a blog network

Recent Posts

  • Wordpress pugins to avoid
  • How to enable the Blogroll in new versions of Word...
  • Ncftp on a dreamhost dedicated server
  • Why you should not disable comments on your blog
  • CSS 101: Cursor control
  • If you are not using PDO, you need to wake up
  • How To Fix "Class 'ZipArchive' Not Found" on Dream...
  • WordPress Backup to Dropbox
  • Back up your WordPress files to the cloud with Dre...
  • WordPress Popunder Plugin

Archives

  • Dec 27, 2011
  • Jan 15, 2012
  • Jan 16, 2012
  • Jan 24, 2012
  • Jan 25, 2012
  • Feb 7, 2012
  • Feb 11, 2012
  • Feb 16, 2012
  • Feb 23, 2012
  • Mar 10, 2012
  • Mar 11, 2012
  • Mar 13, 2012
  • Mar 16, 2012
  • Mar 18, 2012
  • Mar 20, 2012
  • Mar 21, 2012
  • Mar 25, 2012
  • Mar 29, 2012
  • Apr 1, 2012
  • Apr 21, 2012
  • May 1, 2012
  • May 5, 2012
  • May 11, 2012
  • May 12, 2012
  • May 13, 2012
  • May 17, 2012
  • May 25, 2012
  • Jun 6, 2012
  • Jun 13, 2012
  • Jun 15, 2012
  • Jun 26, 2012
  • Jul 14, 2012
  • Jul 30, 2012
  • Sep 13, 2012
  • Oct 17, 2012
  • Nov 1, 2012
  • Nov 22, 2012
  • Dec 19, 2012
  • Dec 24, 2012
  • Dec 25, 2012
  • Jan 2, 2013
  • Jan 16, 2013
  • Jan 21, 2013
  • Jan 27, 2013
  • Feb 13, 2013
  • Mar 3, 2013
  • Mar 12, 2013
  • Oct 3, 2013
  • Current Posts

Powered by Blogger

Subscribe to
Posts [Atom]

Monday, July 30, 2012

How to delete pending comments on a wordpress blog

Via mysql command:

DELETE FROM wp_comments WHERE comment_approved=0

Note: If your comments table is prefixed with wp_something will need to use the correct table name.

Via a plugin:

  • 'Delete pending comments'.
  • 'Bulk comments remove'.
  • 'Akismet'. (it has a 'delete all' button)

posted by Tito | 7:19 AM