From: Date: October 30 2007 11:15am
Subject: Re: Sort results by order in list
List-Archive: http://lists.mysql.com/mysql/209784
Message-Id: <47270454.7050502@pythagoras.se>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi,
what you probably want is
SELECT id, start_date FROM iddt WHERE id IN
('109k7','s3x6','sxmns','wt57')
ORDER BY FIELD(id,'109k7','s3x6','sxmns','wt57')

/Johan

Papalagi Pakeha skrev:
> 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
>