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!
Jason
--
MySQL General
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,
* 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'