create table person(

    id int unsigned auto_increment primary key,

    home_address varchar(16),

    first_name varchar(16),

    last_name varchar(16),

    index ix_first_name_last_name (first_name,last_name)

);

select * from person where first_name like 'abc%';