Database Query To Remove Spam Comments In Wordpress Blog

Hi,

Please execute this query to remove all spam comments from wordpress database:

delete from wp_comments where comment_approved = ’spam’;

This query is assuming that database is configured as default.

Shane G.

Popularity: 7%

Database Query to Enable/Disable Comment Option For WordPress Blog Hi, We can enable/disable comment option from database also. For...
Database Query To Add Post In A Category In WordPress Blog? Hi, Please use this code to add post in a...
How To Reduce Spam Comments In WordPress Blog? Hello All, Before any comment appears on the page it...
How To Remove Canonical Links From Comments In WordPress Blog? Hi, We can easily remove canonical/duplicate comments with the help...
Script To Disable Trackbacks Through SQL Query In WordPress Hello All, One can also disable this trackbacks feature through...

Database Query To Remove Spam Comments In WordPress Blog