SQL Order By Query Trouble

[jjacquay712]

I have a query that combines a limit and order by statement. The trouble is I only want to sort the data that I have limited, not the entire table. Here is an example:

 

SELECT * FROM comments ORDER BY id DESC LIMIT 38,10;

 

Instead of sorting entries 38 to 48, it sorts the entire table, then selects entries 38 to 48. I can't seem to find away around this, I usually could work around this by using this:

 

SELECT * FROM comments WHERE id > 37 AND id < 49 ORDER BY id DESC

 

But using id's to limit wont work in this particular script. Any ideas about what I could do to fix this?

[redarrow]

what it you added the limit of 37> and id<39

[jjacquay712]

What?

[fenway]

It's dangerous to rely on mysql to return rows in any order with an order by clause:

 

SELECT * FROM ( SELECT * FROM comments LIMIT 38,10 ) ORDER BY id DESC;