MySQL DISTINCT with Case Sensitive

Goals

We want MySQL distinct to use case sensitive grouping because by default MySQL use case insensitive.

Solution of MySQL DISTINCT case sensitive

We can use binary operator to convert the character set.

SELECT DISTINCT CAST(expr as BINARY)

As an alternative we can just use BINARY.

SELECT BINARY expr

References

• https://stackoverflow.com/questions/19462919/mysql-select-distinct-should-be-case-sensitive
• https://dev.mysql.com/doc/refman/5.6/en/charset-binary-set.html

Share on Facebook Twitter