ishmael ishmael - 16 days ago 8
MySQL Question

MySQL SELECT DISTINCT should be case sensitive?

How do I make MySQL's SELECT DISTINCT case sensitive?

create temporary table X (name varchar(50) NULL);
insert into X values ('this'), ('This');


Now this query:

select distinct(name) from X;


Results in:


this


What's going on here? I'd like SELECT DISTINCT to be case sensitive. Shouldn't that be the default?

Answer

Use BINARY operator for that:

SELECT DISTINCT(BINARY name) AS Name FROM X;

See this SQLFiddle