MySQL 区分大小写的查询

2021-11-20 00:00:00 mysql case-sensitive

这个网站以前有人问过这个问题,但我找不到足够的答案.如果我正在做这样的查询:

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'

相关文章