Startpoint in a Select query?

[Anon]

Is there a way to start at a special point in MySQL

for instance, I wanna select numbers from a database, (they are in order)

instead of selecting

1
2
3
4
5
6
7
8
9
10

I want only:

5
6
7
8
9
10

I know theres a way I've seen it done before heh.

[ace21]

yeah use a where statement and then an order by

Ace21

[Anon]

Thats not what I mean, I mean if there is a way to cut off the first 5 from the query (I already looked into order by)

[veron]

You want to use limit. So to get the results you want you would use LIMIT 5,5 (offset, number or rows returned)

[Anon]

yep, you rock... thats all I can say