* Mike Johnson > From: Lewis, Jason [mailto:[EMAIL PROTECTED] > > > Didn't know if anyone else might need this but I was given > > the solution. > > > > SELECT * FROM tablename > > ORDER BY MemberLevel='Platinum' DESC, > > MemberLevel='Gold' DESC, > > MemberLevel='Silver' DESC, > > MemberLevel='Paying' DESC, > > MemberLevel='Non-Paying' DESC; > > > > > > Thanks again Mike! > > > Thanks for posting it, actually, as I wasn't aware of that > solution until your question prompted me to go looking.
I think using the FIELD() function is the easiest way: SELECT * FROM tablename ORDER BY FIELD(MemberLevel, 'Platinum','Gold','Silver','Paying','Non-Paying'); <URL: http://www.mysql.com/doc/en/String_functions.html#IDX1261 > -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
