SELECT * FROM table WHERE name LIKE 'a%'; SELECT * FROM table WHERE name LIKE 'A%'; 这样写得到的结果是相同的,如果要使mysql区分大小写,需要加关键字binary SELECT * FROM table WHERE binary name LIKE 'a%'; SELECT * FROM table WHERE binary name LIKE 'A%'; 要在建表时就区分大小写可以这么写 create table table_name( name varchar (20) binary );