Re: does MySQL support function index?

[KimSeong Loh]

No function index in MySQL, but you can index the prefix of a string data type.

Using your example, the following will create the index based on the 1st 2 characters of column TYPE_CODE, assuming it is a string type.
CREATE INDEX I_TYPE_CODE_LAYER1 ON EQ_EQUIP(TYPE_CODE(2));