List:General Discussion« Previous MessageNext Message »
From:Johan Höök Date:October 30 2007 10:15am
Subject:Re: Sort results by order in list
View as plain text  
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
> 
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