… without clicking 8216 times on the spam link in worpdress; you do that like this:
DELETE from wp_comments WHERE comment_approved = ‘0′;
* as Pierre just remarked, it has a name: WordPress macro via SQL
** if you didn’t install it already, Akismet will help drastically reduce any spam on your blog.