Ordering Rows Using a User-Defined Order
By Sean Baird
on 1 September 2000
| 5 Comments
| Tags: ORDER BY
Jonathan writes: "How would I go about ordering results using a specified order in order to offset and limit the results. Say I have non-unique ids, (23, 12, 98, 3) and I need to return rows that contain these ids in the order I specified above. How could I do this without using any extra queries or sub-queries?