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.)

Subscribe to Quantum Tea

Don’t miss out on the latest issues. Sign up now to get access to the library of members-only issues.
jamie@example.com
Subscribe
Follow me on Mastodon