How to get "...WHERE test IN (5,23,2,12,56)" in this order

Hello!

SELECT ...WHERE product_id IN (5,23,2,12,56)

I try to get a list of records in the same order like inside the IN-clause. I do not have a field to sort these and dependent from user- Input its always different (2 to 6 items).

Is this possible? or is there a different way to get records in a particular order without having a field which I can use to sort?

Thank you!

Dirk Received on Thu Jan 10 2002 - 04:44:25 CST