MySQL 区分大小写的查询 [英] MySQL case sensitive query

问题描述

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

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'

这篇关于MySQL 区分大小写的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！