Re: Want ORDER BY to use indexed portion of long text field

[Bob Fitterman]

Chris, thanks for the suggestion, but it still uses filesort. I am stumped. If you want to play with it, here's some SQL to create a test table.

DROP TABLE IF EXISTS `foo`;
CREATE TABLE `foo` (
`id` int(10) unsigned NOT NULL auto_increment,
`var` varchar(10000) NOT NULL,
`txt` text NOT NULL,
PRIMARY KEY (`id`),
KEY `varindex` (`var`(40)),
KEY `txtindex` (`txt`(40))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;