swa66 - 10:33 am on Nov 20, 2012 (gmt 0)
Sure, I used "rank" as a field to define the order. If you chose any other field (text, integers etc: does not matter): use it instead. The order by can sort anything, numbers, dates, text, ... it even understands how text is encoded and does the right thing if you let mysql know of the encoding used and how you want it sorted.
I do think some of my examples rely on the rank being unique, test it well if you could have datasets that have the same value in the order.