February 7, 2023
mytecharticle.com
  • Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Tech News
  • Technical Articles
  • Hosting Articles
  • OpenStack
  • Knowledge Articles
  • Windows Articles
  • Gadgets Articles
  • Linux Articles
  • SQL Tutorials
  • Hosting Tutorials

JBL’s First Earbuds With Touch Screen Display Case

Snapchat+ Created Record 1 million Subscribers

How to Execute Python Files in VS Code

Drag Number Increase Function Not Working in Excel Sheet

Issue: one of source_tags, source_ranges, or source_service_accounts must be defined

SSL certificate problem: self signed certificate in certificate chain

mytecharticle.com
  • Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Tech News
  • Technical Articles
  • Hosting Articles
  • OpenStack
  • Knowledge Articles
  • Windows Articles
  • Gadgets Articles
  • Linux Articles
  • SQL Tutorials
  • Hosting Tutorials
mytecharticle.com
  • Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Tech News
  • Technical Articles
  • Hosting Articles
  • OpenStack
  • Knowledge Articles
  • Windows Articles
  • Gadgets Articles
  • Linux Articles
  • SQL Tutorials
  • Hosting Tutorials
Hosting Articles • Technical Articles

How To Delete All Pending Comments In WordPress

September 17, 2014
1 Min Read
admin
Add Comment
    Share This!
  • Facebook
  • Twitter
  • Google Plus
  • Pinterest
  • LinkedIn

How To Delete All Pending Comments In WordPress

Description:

In wordpress for every post user can post the comments in the published posts.If we enable Akismet plugin wordpress also sometimes spam comments will come for approval.In case you approve it will be big effect on the website.Possibility of website structure too.Here is the simple and flexible solutions to delete thousands of comments at one shot.

Steps:

– Login to the hosting control panel.

– Click on phpMyAdmin.

– Now run the following query in SQL query window.

For All Pending Comments delete

DELETE from wp_comments WHERE comment_approved =  ‘0’

For All Non Approved Comments delete

DELETE from wp_comments WHERE comment_approved =  ‘0’

To Delete Approved comments

DELETE from wp_comments WHERE comment_approved =  ‘1’

To Remove all Spam comments

DELETE from wp_comments WHERE comment_approved = ‘spam’

To Remove all Trash Comments

DELETE from wp_comments WHERE comment_approved = ‘trash’

How to delete Mass Comments in wordpress

If you want to delete the comments using the wordpress plug in install WPCommentCleaner plug in wordpress website.

Tags:wordpress,CMS,wordpress comments,wordpress login,wordpress admin,wordpress installation,wordpress comments,wordpress comments plugin,wordpress comments template,wordpress comments not showing,wordpress comments are closed,wordpress comments.php,wordpress comments captcha,wordpress comments spam,wordpress comments on pages,wordpress comments not working

Post Views: 71
TagsCMS Wordpress wordpress admin wordpress comments wordpress comments are closed wordpress comments captcha wordpress comments not showing wordpress comments not working wordpress comments on pages wordpress comments plugin wordpress comments spam wordpress comments template wordpress comments.php wordpress installtion wordpress login

You may also like

Technical Articles

How to Execute Python Files in VS Code

6 months ago
Docker • Technical Articles

How to Uninstall Kubernetes in Ubuntu

July 20, 2020
Docker • Technical Articles

[ERROR Swap]: running with swap on is not supported. Please disable swap

July 10, 2020

About the author

View All Posts

admin

Add Comment

Click here to post a comment

Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

How To Disable FrontPage Extensions In Whm
How To Create MySQL From cPanel
Comment
    Share This!
  • Facebook
  • Twitter
  • Google Plus
  • Pinterest
  • LinkedIn
Copyright © 2015. Created by Meks. Powered by WordPress.