How do you delete all the pending comments in WordPress
June 10, 2012 / by Marco / Categories : Technology, Wordpress
I fyou get annoyed at all the spammed comments in your WordPress and want to delete all these in one go then there are two options available to delete all the pending comments in your WordPress website. One way is to go into the mysql database via phpadmin and use an SQL statement and delete them all. The statement that you will need to use is:
DELETE FROM wp_comments WHERE comment_approved = 0
The other option is to install the pluging called “delete pending comments” (make sure you type comments with an s). Using this plugin is so much easier than running an SQL statement via phpadmin.
OTHER ARTICLES YOU MAY LIKE
REVIEWING AND UNBOXING THE TOOCKI USB-C RIGHT ANGLE 1.2M CABLE
USB C cables are among the most ordinary accessories we own, yet they can make a surprisingly noticeable difference to how comfortable our devices are to use while charging. The Toocki USB C right angle cable is a good example of a simple accessory that tries to solve a very common irritation, because instead of […]
read more
SUPABASE BACKUP TUTORIAL: USE DBEAVER TO EXPORT YOUR DATABASE SAFELY
If you are building anything serious on Supabase, whether that is a client portal, a SaaS app, an internal dashboard, or even a small side project that is starting to get traction, having a reliable database backup process is one of those tasks that quickly moves from optional to essential. Supabase makes a lot of […]
read more


