Spam comments is really major issue with wordpress. Spam comments will effect your site SEO.
You should delete the spam word comments from wordpress site.
For SEO of your site deleting spam word comments is good.
Here are some steps for protecting your wordpress site.
You may copy and paste the following list to the Comment Moderation box in your wp-admin/options-discussions.php page:
There are some nice plugins also which is helpful for protecting your site from spam comments.
You should activate the Akismet wordpress plugin.
Akismet is quite possibly the best way in the world to protect your blog from comment and trackback spam. It keeps your site protected from spam even while you sleep.
You should check the following option from wordpress:
Before a comment appears: (Options)
- Before a comment appears An administrator must always approve the comment
- Comment author must have a previously approved comment
If you have many spam word comments in your site then you should use sql query for delete the spam comments.
DELETE FROM wp_comments WHERE comment_content LIKE '%<a%'; DELETE FROM wp_comments WHERE comment_author LIKE '%<a%'; DELETE FROM wp_comments WHERE comment_author_url LIKE '%health%';
You should replace the spam comments words in SQL query. Using above sql query you can delete the all spam word comments.
For SEO purpose following options are very important.How to protect from wordpress spam comments words and increase the SEO