hi,

The following query returns a result where the order of the rows is not in the desired order 10,5,9 but 5,9,10. I want to order the returned rows based on how they are ordered in the IN clause.

SELECT * from test WHERE OrderID IN (10,5,9)

OrderID is a primary key in table test

What you have is going to return anything with an order id in that group ordered by the order they are found. (That makes sense, right?.) If you want to explicitly set an order, you should use the ORDER BY clause, however I don't think you can set a "custom" order for an ORDER BY clause. What you may have to do is do a UNION ALL.

If that won't work for your situation (perhaps you have many many orderIDs), the only other thing I can think of right now is to make a new table with your orderids and assign each an "order number" to specify the order in which they should appear. Then join on that table and sort by the order number.

yes, you can

Ahhh, I stand corrected. There's another new trick up the sleeve. Maybe I should stick to the php forums .

Nice to have you back though Rudy.

thank you, i appreciate it, although i am not really back, i was just incredibly bored last night

Awesome
thanks to both of you