WP reminder

By Mike on January 10th, 2005

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: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • bodytext
  • del.icio.us
  • blogmarks
  • NewsVine
  • Reddit
  • StumbleUpon
  • Technorati
  • YahooMyWeb
  • Facebook
  • Google
  • Live
  • Ma.gnolia
  • TwitThis
  • E-mail this story to a friend!
  • Kirtsy
  • Pownce
  • Print this article!

Categories: Miscellaneous
Tags:

One Response to “WP reminder”

  1. katie
    Jan 19th, 2005 at 1:46 pm

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

Leave a Reply

You can use these XHTML tags: <a href="" title=""> <abbr title=""> <acronym title=""> <blockquote cite=""> <code> <em> <strong>

« Working and working out Hiatus »