Landmarks and a gift...

This is a nifty piece of SQL for finding out exactly who entered the five hundredth comment on your blog, assuming you have a WordPress blog with five hundred comments on it.

SELECT *


FROM "WordPress comment table"

ORDER BY comment_date
LIMIT 500 , 1

Right now, I don't have a 500th comment, but it's getting close.  Well within a hundred type of close.  The comment count started on 20th November 2004 when I first moved to WordPress, and I think 500 comments is worth celebrating with a gift for the commenter.  Who's it going to be?  (The gift will have to be decided after the comment arrives, since I doubt Mr Bristow would appreciate yarn if it happens to be him.)