For WordPress websites with good daily visits, there will definitely be a lot of spam comments to be reviewed. If you want to delete them through the WP background, it is simply a very time-consuming and labor-intensive project. Today, we mainly introduce the following two methods to delete spam comments in WordPress. We can execute SQL commands to delete in batches, or delete by enabling the Delete All Pending Comments plug-in.
Method 1: Delete All Pending Commnets plug-in
After searching in the background and installing the Delete All Pending Commnets plug-in, you can click on the left You will see a Pending Comments under the comment menu, go in and check the checkbox, and then click the delete button to delete all comments to be reviewed:
Related recommendations: 《WordPress Tutorial》
Method 2: Delete through SQL command
If you don’t like to mess with plug-ins, and you can manage MySQL by logging in to PhpMyAdmin Database, then you can delete it through SQL commands.
Wordpress comment table is wo_comments, comment_approved is the field of comment response.
Comment_approved is 1: comments passed the review
Comment_approved is 0: comments to be reviewed
Comment_approved is trash: comments in the recycle bin
Comment_approved is spam: Spam comment
The detailed SQL command execution method is as follows. You can change the statement at any time as needed.
1. Delete pending comments, spam comments, and recycle bin comments
delete From ‘wp_comments’ WHERE ‘cooment_approved’ NOT LIKE ‘1’
2. Delete only pending comments
delete From ‘wp_comments’ WHERE ‘cooment_approved’ =‘0’
3 .Only delete spam comments
delete From ‘wp_comments’ WHERE ‘cooment_approved’=’spam’
4.Only delete trash comments
delete From ‘wp_comments’ WHERE ‘cooment_approved’=’trash’
The above is the detailed content of How to delete comments in wordpress. For more information, please follow other related articles on the PHP Chinese website!

Can learn WordPress within three days. 1. Master basic knowledge, such as themes, plug-ins, etc. 2. Understand the core functions, including installation and working principles. 3. Learn basic and advanced usage through examples. 4. Understand debugging techniques and performance optimization suggestions.

WordPress is a Content Management System (CMS). It provides content management, user management, themes and plug-in capabilities to support the creation and management of website content. Its working principle includes database management, template systems and plug-in architecture, suitable for a variety of needs from blogs to corporate websites.

WordPressisgoodforvirtuallyanywebprojectduetoitsversatilityasaCMS.Itexcelsin:1)user-friendliness,allowingeasywebsitesetup;2)flexibilityandcustomizationwithnumerousthemesandplugins;3)SEOoptimization;and4)strongcommunitysupport,thoughusersmustmanageper

Wix is suitable for users who have no programming experience, and WordPress is suitable for users who want more control and expansion capabilities. 1) Wix provides drag-and-drop editors and rich templates, making it easy to quickly build a website. 2) As an open source CMS, WordPress has a huge community and plug-in ecosystem, supporting in-depth customization and expansion.

WordPress itself is free, but it costs extra to use: 1. WordPress.com offers a package ranging from free to paid, with prices ranging from a few dollars per month to dozens of dollars; 2. WordPress.org requires purchasing a domain name (10-20 US dollars per year) and hosting services (5-50 US dollars per month); 3. Most plug-ins and themes are free, and the paid price ranges from tens to hundreds of dollars; by choosing the right hosting service, using plug-ins and themes reasonably, and regularly maintaining and optimizing, the cost of WordPress can be effectively controlled and optimized.

The core version of WordPress is free, but other fees may be incurred during use. 1. Domain names and hosting services require payment. 2. Advanced themes and plug-ins may be charged. 3. Professional services and advanced features may be charged.

WordPress is easy for beginners to get started. 1. After logging into the background, the user interface is intuitive and the simple dashboard provides all the necessary function links. 2. Basic operations include creating and editing content. The WYSIWYG editor simplifies content creation. 3. Beginners can expand website functions through plug-ins and themes, and the learning curve exists but can be mastered through practice.

People choose to use WordPress because of its power and flexibility. 1) WordPress is an open source CMS with strong ease of use and scalability, suitable for various website needs. 2) It has rich themes and plugins, a huge ecosystem and strong community support. 3) The working principle of WordPress is based on themes, plug-ins and core functions, and uses PHP and MySQL to process data, and supports performance optimization.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

WebStorm Mac version
Useful JavaScript development tools