Skip to content

WP reminder

I am alive. Updates forthcoming. In the meantime, should you ever deal with deluges of comment spam in Wordpress, here’s the quick SQL command to run that will clear out all moderated comments:

DELETE FROM `wp_comments` WHERE `comment_approved` = '0'

Share and Enjoy:
  • Digg
  • del.icio.us
  • blogmarks
  • NewsVine
  • Reddit
  • StumbleUpon
  • Technorati
  • Facebook
  • Google Bookmarks
  • Live
  • E-mail this story to a friend!
  • Kirtsy
  • Print this article!
  • LinkedIn
  • Tumblr
  • Posterous
  • RSS
This was written by Mike. Posted on Monday, January 10, 2005, at 1:42 pm. Filed under Miscellaneous. Bookmark the permalink. Follow comments here with the RSS feed. Trackbacks are closed, but you can post a comment.

One Comment

  1. katie wrote:

    Oooh, good idea. I have also had good luck with the Spaminator plug-in.

    Wednesday, January 19, 2005 at 1:46 pm | Permalink

Post a Comment

Your email is never published nor shared.