Visiting blogs by SQL Query

Honestly, it is interesting to get to know the people, leaving comments on blogs. It is a good way to get to know new people. But how to get all that links together without digging through every comment?

Right! Ask the database:

SELECT DISTINCT comment_author, comment_author_url FROM wp_comments WHERE comment_author_url IS NOT NULL ORDER BY comment_author;

This query’s result is an ordered list of nicks and links of every comment and trackback entered. The lazy ones, scared to query the database directly might ask me for a PlugIn I already wrote.


Leave a Reply

Your email address will not be published. Required fields are marked *

Notify me of followup comments via e-mail. You can also subscribe without commenting.