How to Remove Spam from your WordPress site

Rate this post

One of the strengths of WordPress is its interaction with users. However, the interaction portion of WordPress can be abused by spammers. This is a problem often seen in comments. Spam in posts or pages within WordPress is called comment spam.

Spam can be managed within WordPress through plugins or the WordPress Admin interface options. It can also be directly removed through the database. We will be showing how to remove spam with a query in your WordPress database. This will require that you have access to your WordPress database and a database client that can run the query.

Caution: Make sure to approve comments that you want to keep and also make a backup of the WordPress site before applying any changes.


1. Login to the cPanel where your account database can be accessed

2. Launch phpMyAdmin (or your favorite database client)
3. Select the database assigned to your WordPress site
4. Click on the SQL tab
5. Type in the following query: delete from wp_comments where comment_approved=’0′;

6. Click on GO to execute the query

This will remove all of the unapproved comments within your WordPress database without using any plugins

InMotion Hosting was founded in 2001 and provides personal and business web hosting for everyone! For more information about InMotion Hosting and the services we provide see here:



Mazi has nine years of web development experience with the past five years spent honing his skills with WordPress plugins and themes. He's an expert in WooCommerce and is the author of the Simple Sales Tax plugin, a popular sales tax compliance solution for WooCommerce. Brett understands the importance of excellent communication, prides himself on producing high-quality code, and is comfortable working solo or as part of a team.

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also
Back to top button