Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
MySQL commands to delete spam WordPress comments & commentmeta
delete from wp_comments where comment_approved='spam';
delete from wp_commentmeta where comment_id not in (select comment_id from wp_comments);
delete from wp_commentmeta where meta_key like '%akismet%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment