MySQL Forums
Forum List  »  General

Re: Can MySQL go backwards through index?
Posted by: Tom Byars
Date: March 09, 2015 03:59AM

I suppose those queries should include an order by clause

select * from LargeTbl where Col1 = Col1Val and Col2 < Col2Val
order by Col2 desc limit 10;

and

select * from LargeTbl where Col1 = Col1Val and Col2 > Col2Val
order by Col2 limit 10;

Options: ReplyQuote


Subject
Written By
Posted
Re: Can MySQL go backwards through index?
March 09, 2015 03:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.