Re: Strange ORDER BY question(SOLUTION)

2004-01-12 Thread Roger Baklund
* 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

RE: Strange ORDER BY question(SOLUTION)

2004-01-12 Thread 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='N

RE: Strange ORDER BY question(SOLUTION)

2004-01-12 Thread Lewis, Jason
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