List:General Discussion« Previous MessageNext Message »
From:Papalagi Pakeha Date:October 30 2007 9:40am
Subject:Re: Sort results by order in list
View as plain text  
On 10/30/07, Sebastian Mendel <lists@stripped> wrote:
> Papalagi Pakeha schrieb:
> > Hello,
> >
> > I have a query like:
> > SELECT id, start_date FROM iddt WHERE id IN ('109k7','s3x6','sxmns','wt57');
> > which gives me:
> > +-------+---------------------+
> > | id    | start_date          |
> > +-------+---------------------+
> > | 109k7 | 2007-10-07 12:06:58 |
> > | sxmns | 2007-10-06 02:17:30 |
> > | wt57  | 2007-10-07 15:57:37 |
> > | s3x6  | 2007-10-07 08:58:20 |
> > +-------+---------------------+
> >
> > How can I get the results sorted by the order in which they appear in
> > the ID list?
>
> i do not fully understand ... ORDER BY `id` ... ???
> what ID List?

This ID list:  ('109k7','s3x6','sxmns','wt57')
I.e. I want to get the results in the same order in which they appear
in the above list. 109k7 first, s3x6 second, etc. Simple WHERE id IN
(...) gives me random order.

PaPa
Thread
Sort results by order in listPapalagi Pakeha30 Oct
  • Re: Sort results by order in listPeter Brawley30 Oct
    • Re: Sort results by order in listPapalagi Pakeha30 Oct
      • Re: Sort results by order in listPeter Brawley30 Oct
  • Re: Sort results by order in listSebastian Mendel30 Oct
    • Re: Sort results by order in listPapalagi Pakeha30 Oct
      • Re: Sort results by order in listJohan Höök30 Oct
        • Re: Sort results by order in listPapalagi Pakeha30 Oct