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

Re: Strange ORDER BY question

2004-01-12 Thread Tobias Asplund
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

RE: Strange ORDER BY question

2004-01-12 Thread Mike Johnson
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