mysql like查询时区分字母大小写

 

原：

SELECT tag FROM goods WHERE tag LIKE '%24H发货%'

 

查询时区别大小写：

SELECT tag FROM goods WHERE BINARY tag LIKE '%24H发货%'