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

MySQL: Updating Table using UPDATE REPLACE Query

This query is quite helpful when you moving from development machine to production where your table content is full of dozen 'http://localhost/' links.

Syntax

UPDATE [table] SET [column] = REPLACE(
  [column],
  [old_value],
  [new_value]
) WHERE [column] LIKE [old_value];

Read more »

Share on Facebook Twitter