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. -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
