Order by problem

[JimFL]

Hi,

Is there any way that I can optimse this query so that I return the order passed in by the mysql query.

The reason I am trying to do this is because I have already defined my order in a previous array function and I am passing in a string as a list of ID's


For example


SELECT xID FROM X1 x WHERE x.xID in(481,1,373,3,429,480,427,187,2,464,604,224,567,219,484,577,190,546) limit 0, 5

Can this be done within the same query or do I need to make a seperate temporary table and then use the order by function?

Would appreciate any help on this.

JimFl

 

[r937]

SELECT xID 
  FROM X1 x 
 WHERE x.xID in (481,1,373,3,429,480,427,187
                ,2,464,604,224,567,219,484,577,190,546) 
order
    by field(xID,481,1,373,3,429,480,427,187
                ,2,464,604,224,567,219,484,577,190,546)  
limit 0, 5

r937.com | rudy.ca

 

[JimFL]

Absoulutely what I was looking for - thanks