MySQL 区分大小写的查询
这个网站以前有人问过这个问题，但我找不到足够的答案.如果我正在做这样的查询:
This has been asked on this site before but I couldn't find a sufficient answer. If I'm doing a query like:
Select Seller from Table where Location = 'San Jose'
如何让它只返回位置为圣何塞"而不是圣何塞"或其他名称的卖家?
How can I make it return only Sellers with Location 'San Jose' instead of 'san jose' or something else?
推荐答案
默认情况下，MySQL 查询不区分大小写.以下是一个寻找 'value' 的简单查询.但是它会返回 'VALUE'、'value'、'ValUE' 等......
MySQL queries are not case-sensitive by default. Following is a simple query that is looking for 'value'. However it will return 'VALUE', 'value', 'VaLuE', etc…
SELECT * FROM `table` WHERE `column` = 'value'
好消息是，如果您需要进行区分大小写的查询，使用 BINARY 运算符，强制逐字节比较:
The good news is that if you need to make a case-sensitive query, it is very easy to do using the BINARY operator, which forces a byte by byte comparison:
SELECT * FROM `table` WHERE BINARY `column` = 'value'
相关文章