表里数据
SELECT * from user WHERE userid='Admin'
可以查出数据
在条件字段的前面加上BINARY
SELECT * from clusers WHERE BINARY userid='Admin'
查不出数据
如果是模糊查询
select * from user where username like binary('admin') and password like binary('admin');
表里数据
SELECT * from user WHERE userid='Admin'
可以查出数据
在条件字段的前面加上BINARY
SELECT * from clusers WHERE BINARY userid='Admin'
查不出数据
如果是模糊查询
select * from user where username like binary('admin') and password like binary('admin');