• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Baguiowebs

Baguiowebs

Learn WordPress. Build Your Own Site.

  • Contact
  • Build a Site
  • WP Training
  • Library
  • Signup
  • Login
  • Contact
  • Build a Site
  • WP Training
  • Library
  • Signup
  • Login

WordPress Clean Up: Clear Out Any Spam

Hi, Login
X

Join Us Forgot Password?

to view this video. Not a member? Join Now!

Use the below code snippets to clean up spam comments as shown in video above. Remember to FIRST do an EXPORT (Backup) of your Database BEFORE doing any of the querrys.

Mass Delete all Spam Comments

DELETE FROM wp_comments WHERE comment_approved = 'spam';

Mass Delete all Trash Comments

DELETE FROM wp_comments WHERE comment_approved = 'trash';

Mass Delete all Approved Comments

DELETE FROM wp_comments WHERE comment_approved = '1';

Mass Delete all Pending Comments

DELETE FROM wp_comments WHERE comment_approved = '0';

Important!

Make sure the prefix is correct for your db. If it is not the default wp or something you made custom, then replace wp with your custom prefix.

For example, I changed my prefix from wp into bgws so my query must be like this:

DELETE FROM bgws_comments WHERE comment_approved = '0';

Filed Under: WordPress Maintenance

Primary Sidebar

Section 11

WordPress Maintenance

Introduction

  • Introduction to WordPress Maintenance1:31min

Backups

  • Full "Fool-Proof" Backup6:29min
  • How to Backup and Restore4:50min

WordPress Updates

  • How to Update WordPress Core4:40min
  • How to Update WP Themes and Plugins6:38min

WordPress Clean Up

  • WordPress Clean Up: Post Revisions5:13min
  • WordPress Clean Up: Remove Unused Plugins3:50min
  • WordPress Clean Up: Remove Unused Themes2:27min
  • WordPress Clean Up: Clear Out Any Spam5:31min
  • How to Replace WordPress Salts3:38min
  • How to Review Error Logs in WordPress6:11min

Site Health & Monitoring

  • How to Test Downtime for Your WordPress Site5:29min
  • Uptime Monitoring for WordPress Sites4:15min
  • How to Run Site Tests – Site Health Testing6:41min
  • How to Do Page Speed Tests5:15min
  • Malware Site Check for WordPress3:00min
  • How to Check For Broken Links5:44min

Optimization

  • How to Optimize Images5:11min
  • How to Optimize WordPress Database4:04min
  • How to Create a WordPress Child Theme5:59min

Copyright © 2022 Baguiowebs. All Rights Reserved.

  • About
  • Disclaimer
  • Privacy Policy
  • Terms