Skip to content

Instantly share code, notes, and snippets.

@manovotny

manovotny/delete-spam-and-orphaned-comments.sql

Last active September 18, 2015 14:50
Show Gist options
  • Save manovotny/dd5a44121356495e7222 to your computer and use it in GitHub Desktop.
Save manovotny/dd5a44121356495e7222 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Query to Mass Delete Spam and Orphaned Comments from WordPress
Raw
delete-spam-and-orphaned-comments.sql
DELETE FROM
wp_comments
WHERE
comment_approved = 'trash'
OR comment_approved = 'spam';
DELETE FROM
wp_commentmeta
WHERE
comment_id NOT IN (SELECT comment_ID FROM wp_comments);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment