Delete self-pings

It seems that self-pings are bad for Google page ranking. Well, I have never spended too much time thinking about SEO but I find them a bit clutering and thus I’ve decided to remove them. There are some plugins which block new self-pings but none which deletes the existing ones. So here is a mysql command which does just that:

Warning: don’t execute sql commands on your db if you don’t know anything about what sql is, it might ruin your base.

<pre lang="SQL" line="0">select count(*) from {prefix}_comments where comment_type = 'pingback' and
    locate((select option_value from {prefix}_options where option_name = 'siteurl'), comment_author_url) = 1;
delete from {prefix}_comments where comment_type = 'pingback' and
    locate((select option_value from {prefix}_options where option_name = 'siteurl'), comment_author_url) = 1;

Replace the {prefix} with your db tables prefix.