I've got a bit of a strange question, a short version of the sql I'm using is
SELECT * FROM table WHERE id IN (5,10,1,9)
Is there a way to get the results in the same order as the IN clause? so the results should be ordered by the id and be returned as 5,10,1,9
Maybe im not thinking about it the right way but its ran from within a vb.net app and the IN(x) is generated from somewhere else.
On a side note is it better performance wise to use IN OR Where id= 5 AND id = 10 etc, sometimes its up to about 20 ids.
Thanks :)