DELETE FROM `wp_comments` WHERE `wp_comments`.`comment_approved` = "spam";
If you want to export your database it can become a massive file from comment spams. Use the above query to remove comments spams from the comments table.
Hone Watson
-
Recent Posts
- Drupal 6 node.save services taxonomy xmlrpc php and python
- Nginx WordPress Mu FastCgi_Cache Conf Rewrites
- Trac configured with Nginx MySql Python SVN on Ubuntu
- Magento Sucks
- Python Gmail imaplib search subject get attachments
- menu.inc on line 2423 Duplicate entry menu router fix Drupal 6
- CSS WordPress Thematic
- perl: warning: Please check that your locale settings ubuntu
- Bulk Optimize Jpg’s Ubuntu Linux Command Line
- Upload Image WordPress Error Problem
- Hot Magazine News Blog Layouts
- Resize Elastic Block Store Volume Snapshot MySql XSF
- Ie6 Internet Exporer Install Ubuntu Ibex Intrepid Wine Tricks
- Copy MySQL Binaries
- Chemicals Feminizing Men – Low Fertility – Less Men – Men the Weaker Sex
-
Top Posts
- Why men are so horny
- Postfix Gmail SMTP Relay
- Python List Compare Difference - Python Sets
- Ie6 Internet Exporer Install Ubuntu Ibex Intrepid Wine Tricks
- Wordpress Form and Submit Article Plugins
- perl: warning: Please check that your locale settings ubuntu
- Vim Search and Replace Regex Patterns
- Linux Command Line "Search and Replace" Text in Files Recursively "Find and Replace" Grep Sed Python Regex Regular Expression
- Find and Remove Hidden Folders .svn Ubuntu Linux Command Line
- BigTable GQL ER Entity Relationship Database Tutorial for Google App Engine
- Python and Grep Regular Expressions Tutorial
- Nginx Wordpress Mu FastCgi_Cache Conf Rewrites
2 Comments
Thanks for the delete comments tip in WordPress!
That is nice tips to remove annoying spam