mysql的索引建多了_mysql – 如何根据一行的字段在索引上创建多个条目？

如果我理解正确,这个查询应该有效：

SELECT id FROM testTag WHERE LOCATE('bar', CONCAT(tag1,'.',tag2,'.',tag3)) > 0;

鉴于此表结构：

CREATE TABLE `testTag` (

`id` int(11) NOT NULL,

`tag1` varchar(10) DEFAULT NULL,

`tag2` varchar(10) DEFAULT NULL,

`tag3` varchar(10) DEFAULT NULL,

PRIMARY KEY (`id`),

KEY `tags` (`tag1`,`tag2`,`tag3`)

) ENGINE=InnoDB

mysql> EXPLAIN SELECT id FROM testTag WHERE LOCATE('bar', CONCAT(tag1,'.',tag2,'.',tag3)) > 0;

+----+-------------+---------+-------+---------------+------+---------+------+------+--------------------------+

| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |

+----+-------------+---------+-------+---------------+------+---------+------+------+--------------------------+

| 1 | SIMPLE | testTag | index | NULL | tags | 39 | NULL | 15 | Using where; Using index |

+----+-------------+---------+-------+---------------+------+---------+------+------+--------------------------+