mysql用like区分大小写用法

MYSQL使用LIKE匹配时默认是不区分大小写的.
例：

select * from table_name where a like 'wss%'
select * from table_name where a like 'WSS%'

匹配的结果是一致的.

区分大小写匹配：

select * from table_name where binary a like 'wss%' 
select * from table_name where binary a like 'wss%' 

这样就能区分大小写匹配