MySQLでLIKEを使う時の実験 - Qiita

CREATE TABLE table ( a varchar(255), b varchar(255), KEY 'a' ('a'), KEY 'b' ('b'), ); mysql> explain select * from table where a LIKE "abc%"; +----+-------------+-----------+------------+-------+---------------+------+---------+------+------+----------+-----------------------+ | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra | +----+---