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"等……

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'

好消息是，如果您需要进行区分大小写的查询，使用

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屋！