… 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.
Tags: admin, comment, mysql, spam, wordpress | Comments (0)
Just noticed that one: the link of author commenting on Capacity were broken. I managed to fix this by editing the comments-templates inside the /includes – I’m not sure this is a WP2.7 issue but i thought it might help to get a not on this in the future…
/wp-includes/comment-templates.php line 148: replace the single quotes by escaped double quotes
$return = "<a href=\"$url\" rel=\"external nofollow\" class=\"url\">$author\</a>";