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

 

原:

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

 

查询时区别大小写:

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

 

posted @ 2022-05-13 09:27  zagwk  阅读(151)  评论(0)    收藏  举报