From: Date: October 30 2007 10:40am
Subject: Re: Sort results by order in list
List-Archive: http://lists.mysql.com/mysql/209783
Message-Id: <343d1bca0710300240x6a363ffao149baef5fc770cb4@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

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