How to show records from a specific ID

[ins-coder]

[b]MySQL[/b]

+----+
| id |
+----+
| 1  |
+----+
| 2  |
+----+
| 3  |
+----+
| 4  |
+----+
+----+
| 5  |
+----+

 

How do I show records from a specific ID so the list would show 2,3,4,5 or 3,4,5?

 

I figured to do with two queries in UNION but end up showing 2,1,3,4,5 or 2,5,4,3,1.

[Pikachu2000]

You haven't provided enough information for anyone to figure out what it is you're really after.

[smoseley]

SELECT *

FROM table_name

WHERE id IN (2,3,4,5)

ORDER BY id ASC;