Database Query To Remove Spam Comments In WordPress Blog

Posted by

Hi,

Please execute this query to remove all spam comments from wordpress database:

delete from wp_comments where comment_approved = ’spam’;

This query is assuming that database is configured as default.

Shane G.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.