Simple to use. Looking for a link in comments field:
MySQL Code to Run


DELETE FROM wp_comments WHERE comment_approved='0' AND comment_content like '%http%' ;