How to manually delete all pending posts in WordPress?

Imagine, you are running a WordPress site with an article/news submission form. Over the period of time, many SPAM posts will accumulate under the header “Pending” and consumes a huge database space. You will be able to view the total number of posts if you login to dashboard.

You have to delete all unncecessary pending posts regularly and can be done either using a plugin like Bulk Delete or manyally from PHPMyAdmin.

You can make use of Bulk Delete WordPress plugin if the total number of pending posts is less than 50. If there are more than 100 pending posts, it is better to make use of SQL Commands from within PHPMyAdmin.

1) Login to PHPMyAdmin

2) Select your database

3) Run the following SQL command by clicking the query window

DELETE FROM wp_posts WHERE post_status = "pending";

The above command will delete all your unwanted pending posts within 20 seconds. Please make sure to backup your existing MySQL database before running the above command.

NOTE: PHPMyAdmin can be accessed from Database Manager section in HELM Control Panel (Windows Server) and inside CPanel (Linux Servers)

READ  Microsoft Adds New Visual Studio Online and Team Foundation Server Features Timeline

2 Responses to "How to manually delete all pending posts in WordPress?"

  1. I always used to read paragraph in news papers but now as I am a user of net thus from now I am using net for posts, thanks to web.

  2. best article spinner software   October 4, 2014 at 2:15 pm

    Hello! I could have sworn I’ve been to this site before but after reading
    through some of the post I realized it’s new to me.
    Anyhow, I’m definitely happy I found it and I’ll be
    book-marking and checking back frequently!


Leave a Reply

Your email address will not be published.