Sarathlal N

Delete all spam comments in WordPress using SQL query

When I start to deal with WordPress for clients, always some of them complaint about spam comments. We can use some Spam protection plugins to control spam.

But if a real human being type his promotional words & links in comments, we have limitations. We want to manually mark it as spam to protect our blog.

When we mark comment as spam, they are still in our database. So now we are going to remove these unwanted spam from our database using a simple SQL query.

DELETE FROM wp_comments WHERE comment_approved = 'spam';

Try this query & help to keep our database as optimized.

Need Help?

Do you need any help on WordPress? I'm happy to help you.

Contact Me

Recent Posts

  1. Get variation product data on selecting variation options - WooCommerce
  2. Add TinyMCE WYSIWYG (Rich text area) meta box - WordPress
  3. Reorder product tabs in single product page - WooCommerce
  4. Download webpage for offline reading - wget
  5. Remove product tabs in single product page - WooCommerce

Your Questions / Comments

If you found this article interesting, found errors, or just want to discuss about them, please get in touch.