MySQL case sensitive query

Question

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

User · Answer

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'

User · Answer

To improve James  excellent answer   It s better to put BINARY in front of the constant instead   SELECT   FROM  table  WHERE  column    BINARY  value    Putting BINARY in front of column will prevent the use of any index on that column

User · Answer

Whilst the listed answer is correct  may I suggest that if your column is to hold case sensitive strings you read the documentation and alter your table definition accordingly   In my case this amounted to defining my column as    tag  varchar 255  CHARACTER SET utf8 COLLATE utf8 bin NOT NULL DEFAULT      This is in my opinion preferential to adjusting your queries

[mysql] MySQL case sensitive query

Examples related to mysql

Examples related to case-sensitive