Comments is a important thing in blog environment. Nowadays more websites are affected by spam comments. Here yon can remove your spam comments by following simple steps
There are 2 types of spam comments.
1. Man made spam comments
It is done by hand posting in particular website only for fun
2. Spam Robots
Its a little internet programs . It used to look around for websites and post unwanted comments on it
How to remove spam comments
Step 1 : Login to cPanel
Step 2 : Select PhpMyAdmin
After login cPanel you can view the PhpMyAdmin under the section of databases. Select the phpMyAdmin to process further
Step 3: Select Database and SQL
Select your required database, Where you can see the option like structure , SQL, search,Query
Click the SQL
Step 4 : Enter below SQL command
After clicking on the SQL and then enter the below mentioned command to remove spam comments
DELETE from wp_comments WHERE comment_approved = ‘0’;
Step 5 : Save
Atlast verify your commands and then click GO option to save the command
