List:General Discussion« Previous MessageNext Message »
From:mos Date:January 23 2004 3:41pm
Subject:Re: Order by problem
View as plain text  
>
>The following might help, but will certainly be quite slow:
>
>SELECT ... ORDER BY ABS(SUBSTRING(field, 4));
>
>A better (and faster) solution will probably be indexing the records with 
>a numeric field, as usual.

Fred,
         Doesn't MySQL always physically sort the rows and not use the 
index to obtain row order? Do you (or anyone else listening) know of a way 
to get MySQL to use the index for sorting instead of physically sorting the 
rows? TIA

Mike



Thread
Order by problemSagar C Nannapaneni23 Jan
  • Re: Order by problemMartijn Tonies23 Jan
  • Re: Order by problemBenoit St-Jean23 Jan
  • Re: Order by problemFrederic Wenzel23 Jan
    • SELECT statementGary Broughton23 Jan
    • Re: Order by problemmos23 Jan
  • Re: Order by problemmos23 Jan