Skip to content

Instantly share code, notes, and snippets.

@lschatzkin

lschatzkin/kill spam comments

Created May 7, 2013 22:40
Show Gist options
  • Save lschatzkin/5536762 to your computer and use it in GitHub Desktop.
Save lschatzkin/5536762 to your computer and use it in GitHub Desktop.
Download ZIP
delete all SPAM (unapproved) comments in MySQL, using SequelPro / PHPAdmin / command line.
Raw
kill spam comments
DELETE FROM wp_comments WHERE comment_approved=0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment