Hey all,
I have a query that returns results from a MySQL DB. One of the columns is called rating and has a value of either Gold, Silver, or Platinum. I need the results to be sorted by the rating column in such a way that Platinum is at the top, Silver is next, and Gold is displayed last. I know how to do this obviously if the rating was a number but how do you do it with text labels? You can't do it reverse alphabetically or alphabetically because it needs to go P-S-G.
TIA!
