use test;
create table t
(
a varchar(128) null
);
INSERT INTO test.t (a) VALUES ('a');
INSERT INTO test.t (a) VALUES ('aa');
INSERT INTO test.t (a) VALUES ('aaa');
INSERT INTO test.t (a) VALUES ('aaaa');
SELECT count(*) from test.t where left(t.a,1)="a";