Remove comments from Wordpress
Popular Internet resources, especially information portal and shopping are often faced with the increased waves of spam comments ordinary users. Everyday disposal of such records is extremely removes and takes a lot of time, and sometimes poor quality administration, and in general can lead to clogging of the tape only spam and loss of members. Sites created based on Wordpress, assume the standard deleting comments in groups of 20 posts, which is extremely effective in the fight against spam. There is a simpler and faster way to deal with the problem of the removal of non-approved comments en masse. To do this, just go through the following sequence of actions:
1) Go to phpmyadmin and select the desired base WordPress
2), proceed to the SQL tab and run the following query:
DELETE FROM wp_comments WHERE comment_approved = '0';
To remove also approved comments repeat simple algorithm to change the query to the following:
DELETE FROM wp_comments WHERE comment_approved = '1';
Thus, in a few clicks you get a completely clean site without a single superfluous comment. On the other hand, if you get rid of the comments, it might be worth and commenting on the function to get rid?