wordpress spam sql query

This SQL query will kill all your wordpress spam comments.

delete from wp_comments where comment_approved = '0'
Advertisements