On 10/30/07, Sebastian Mendel <[EMAIL PROTECTED]> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
