Re: indices not used

[Martin Luy]

quotes were missing again... sorry...

EXPLAIN(SELECT * FROM `products` WHERE c1 = '22' AND c2 = 5 AND c3 = 2 ORDER BY factor DESC)

id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE products ref keyname keyname 22 const,const,const 46397 Using where



SHOW CREATE TABLE products;

phpMyAdmin 2.9.1.1-Debian-8 / MySQL 5.0.51a-9-log

CREATE TABLE `products` (
`id` bigint(20) NOT NULL,
`c1` varchar(3) default NULL,
`c2` int(4) default NULL,
`c3` int(4) default NULL,
PRIMARY KEY (`id`),
KEY `keyname` (`c1`,`c2`,`c3`,`factor`)
) ENGINE=MyISAM AUTO_INCREMENT=106221415 DEFAULT CHARSET=utf8


Well, now it works. Thanks for your help!
Martin