Delete all Spam from MovableType Database

| | Comments (0)
I had over 6000 already tagged spam comments in my database from using SCode and reCAPTCHA within MovableType.  But couldn't find a "delete all spam" from the admin dashboard.

Here is a sql statement to do it manually:
delete from mt_comment where comment_junk_status < 0;

Leave a comment

Verification (needed to reduce spam):

Amazon Lists

About this Entry

This page contains a single entry by Shawn published on May 21, 2008 10:39 PM.

Upgraded to MovableType 4.1 was the previous entry in this blog.

Find recent content on the main index or look in the archives to find all content.