mysql查询不区分大小写

查表

    select * from TableA where binary columnA ='aaa';

建表

create table some_table(
   str char(20) binary 
)