Delete more than 20 comments at once in WordPress
James Edward Anthony
Content Writer
Each time we have to delete those spam comments but unfortunately we can delete only 20 comments at once, this become really annoying when we have to delete thousands of comments, as it takes lots of time and a boring procedure.
Conclusion on deleting WordPress comments
Delete more than 20 comments at once in WordPress
This is a quick guide on how you can delete more than 20 comments at once in WordPress. Let's dive in without further delay!There are lots of blogs that are getting thousands of comments that include spam comments. Having spam comments on your blog or website can be harmful to your SEO score. This is why deleting spam comments become necessary. But unfortunately, WordPress only allows you to delete 20 comments at once. That does not mean there is no way to delete more than 20 comments at once, because there are!There are two methods in order to delete pending comments, these are followings:
- Plugin: Delete Pending Comments Plugin.
- Software: PHPMyAdmin.
Method 1. Using Delete Pending Comments Plugin
Delete Pending Comment plugin allows you to delete exactly what it states: to delete pending comments. It is a very useful and must-have plugin if your website or blog is really popular and gains a lot of traction and comments. You may choose to download their plugin on their download page . Furthermore, their website also has a FAQ section that provides all the required information you need.If you do not like this one, or if you want something else, there are various alternatives to this option. One of them is WP Bulk Delete. It allows a much greater control overall in deleting content on your website, including spam comments. Be careful while you tread around this option.
Method 2. Using PHPMyAdmin
Deleting pending comments through PHPMyAdmin is easy enough if you have little knowledge about PHPMyAdmin and SQL query. Just follow the steps below:
- Open your website and navigate to PHPMyAdmin Icon. After that click on it.
- In PHPMyAdmin select the appropriate WordPress database
- Run the following command from SQL: delete from wp_comments where comment_approved = '0'
Conclusion on deleting WordPress comments
Be advised that you should make a backup before you proceed with mass deleting the comments. You don't want to end up deleting what you were not supposed to delete.If you need further help on WordPress websites, you may choose to contact us for more information. If you need any help regarding Website Design instead, feel free to check out our Website Design Package.
Ready to get started?
Get an instant quote and launch your project today.
More articles
View all
Design & DevHaving a Landing Page for a Website in South Africa
Whenever a user clicks on a hyperlink through a search engine result's page, they often visit a landing page. A landing page is a webpage where the user 'lands' on your website after clicking on a link. What's so important about having these landing pages for your website in South Africa? Let's find out in [...]
Read more
Design & DevFive Simple Web Development Projects for Beginners in 2023
Are you interested in formatting and coding a website, but never got a chance to do so? You do not have any coding background, yet you wish to create websites for fun and learning. Then this article is for you. In this article, we will explore five simple web development projects for beginners in South [...]
Read more
Design & DevBuilding a Website in South Africa? Here are the Assets you Need.
In South Africa, it is crucial for your small business to have a website. With many free and paid website builder options to choose from, you need little to no coding knowledge to bring your dream website to life (Source: Forbes). However, there are certain things to be mindful of, that generally no one would [...]
Read more