MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Want ORDER BY to use indexed portion of long text field
Posted by: Chris Schneider
Date: October 24, 2007 03:06PM

Not sure if this will work but give it a try and let me know.

order by CAST(substring(txt, 1,40) as CHAR) asc limit 40;

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Want ORDER BY to use indexed portion of long text field
6687
Bob Fitterman
October 13, 2007 07:03AM
Re: Want ORDER BY to use indexed portion of long text field
2890
Chris Schneider
October 24, 2007 03:06PM
Re: Want ORDER BY to use indexed portion of long text field
3051
Bob Fitterman
November 15, 2007 09:20AM
Re: Want ORDER BY to use indexed portion of long text field
2754
KimSeong Loh
November 15, 2007 03:51PM


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.