Search code examples
mysqlsqldatabasedistinctcase-insensitive

MySQL case-insensitive DISTINCT

Can anyone tell me how i can SELECT DISTINCT from my database without it being case-sensitive?

My query is 

SELECT DISTINCT email FROM `jm_order`

The results brings out all the emails in the table but repeats the ones with different cases. This is expected because the values are different case wise. e.g

[email protected]
[email protected]
[email protected]
[email protected]

But what i want is for the same emails, to be grouped together regardless of the case. What adjustment can i make to my SQL to stop it from repeating for example [email protected] and [email protected] just because they are different cases?

Solution

  • Try to use upper function 

    SELECT DISTINCT UPPER(email) FROM `jm_order`

    you can also use lower instead

    SELECT DISTINCT LOWER(email) FROM `jm_order`

    More information.