In preparation for this weekend’s 4-year anniversary episode of the Journey Inside My Mind podcast, I’ve gone through the comments made on this blog, and have produced this list. It was compiled from the MySQL database that powers my WordPress blog, with the query:

SELECT DISTINCT `comment_author` , `comment_author_url`
FROM wp_comments
ORDER BY `comment_author` ASC

After cleaning up the list in Excel, I’ve got this of everyone who has commented and has left a link. Thank you to everyone who has been involved over the past four years or more:

• Andy K
• Breanna Gaddie
• Dave Delaney
• Doctor Anonymous
• Hairstyles Watch
• jimi lee
• John Buehler
• Lois
• minimumspecs
• MoochChaCha
• Much To Do About Nothing, the Blog
• nFriedly
• Rich Palmer
• salguod
• sierra
• UK Solicitors
• Vicki

I think I’m going to try this out for my other blogs as well.  Thanks also to Chris Penn for the idea.

Possible related articles by Zemanta

• A micro-benchmark of stored routines in MySQL (mysqlperformanceblog.com)
• Display Recent Comments in WordPress (franklinbishop.net)
• Tutorial: Any Church or Ministry Can Podcast (bloggingministry.com)