Supprimer les commentaires avec des liens dans wordpress

Pas très performant mais efficace au final:

DELETE FROM `wp_comments` WHERE `comment_approved` = 0 AND `comment_content` LIKE "%<a%href=%";
DELETE FROM `wp_comments` WHERE `comment_approved` = 0 AND `comment_content` LIKE "%http://%";
DELETE FROM `wp_comments` WHERE `comment_approved` = 0 AND `comment_content` LIKE "%[url=%";

Difficile de lutter contre les spammers.