mysql SQL 查询条件 不区分大小写

zhgc

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

syant

不区分大小写
SELECT * FROM users WHERE username COLLATE utf8_general_ci = myVar;