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.
Advertisement
Hone Watson
-
Recent Posts
- App Engine StringListProperty Merge Join Attributes Pattern
- Python @staticmethod vs @classmethod
- Recursive Grep
- Drupal 6 Redirect Form hook_form_alter
- Best Drupal Blog Tips
- Svn add all new files
- k2 search engine friendly seo url’s Artio JoomSef sef Fix for Joomla
- 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
- 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
-
Top Posts
- perl: warning: Please check that your locale settings ubuntu
- Why men are so horny
- Postfix Gmail SMTP Relay
- Find and Remove Hidden Folders .svn Ubuntu Linux Command Line
- Python List Compare Difference - Python Sets
- Wordpress Form and Submit Article Plugins
- Error opening CA private key ./demoCA/private/cakey.pem
- Python Gmail imaplib search subject get attachments
- The plain HTTP request was sent to HTTPS port
- mysqlimport: Error: Table 'database.mydatabase' doesn't exist
- Linux Command Line "Search and Replace" Text in Files Recursively "Find and Replace" Grep Sed Python Regex Regular Expression
- BigTable GQL ER Entity Relationship Database Tutorial for Google App Engine
2 Comments
Thanks for the delete comments tip in WordPress!
That is nice tips to remove annoying spam