Hi,
It comes from external source together with Relevance value (float),
where the first ID has highest relevance and subsequent IDs are in
decreasing order.
For example:
109k7 1.79
s3x6 1.34
sxmns 1.21
wt57 0.93
I could use these numbers in the query as well if it helps.
PaPa
On 10/30/07, Peter Brawley <[EMAIL PROTECTED]> wrote:
> >I.e. the ideal output would be:
> >+-------+---------------------+
> >| id | start_date |
> >+-------+---------------------+
> >| 109k7 | 2007-10-07 12:06:58 |
> >| s3x6 | 2007-10-07 08:58:20 |
> >| wt57 | 2007-10-07 15:57:37 |
> >| sxmns | 2007-10-06 02:17:30 |
> >+-------+---------------------+
>
> What rule generates the order 109k7, s3x6, wt57, sxmns?
>
> PB
>
> Papalagi Pakeha wrote:
> > 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? Indeed I could do it in the application but prefer to get
> > the results in the right order from MySQL as the ID list may be long
> > and I may need only first few entries cropped by LIMIT clause. Ideally
> > it should ORDER BY DATE(start_date) DESC and then by the ID list. Do I
> > need some sort of stored function for that?
> >
> > I.e. the ideal output would be:
> > +-------+---------------------+
> > | id | start_date |
> > +-------+---------------------+
> > | 109k7 | 2007-10-07 12:06:58 |
> > | s3x6 | 2007-10-07 08:58:20 |
> > | wt57 | 2007-10-07 15:57:37 |
> > | sxmns | 2007-10-06 02:17:30 |
> > +-------+---------------------+
> >
> > Thanks
> >
> > PaPa
> >
> >
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
