* 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,
> > MemberLe
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='N
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
On Mon, 12 Jan 2004, Lewis, Jason wrote:
> Okay I have a field in my db called MemberLevel in this field you can be one of 5
> levels.
>
> Platinum
> Gold
> Silver
> Paying
> Non-Paying
>
>
> now my question is, how would I ORDER BY MemberLevel and get it to come out in the
> above order? I have
From: Lewis, Jason [mailto:[EMAIL PROTECTED]
> Okay I have a field in my db called MemberLevel in this field
> you can be one of 5 levels.
>
> Platinum
> Gold
> Silver
> Paying
> Non-Paying
>
>
> now my question is, how would I ORDER BY MemberLevel and get
> it to come out in the above