title: MySQL case-insensitive DISTINCT
body: <p>Can anyone tell me how i can SELECT DISTINCT from my database without it being case-sensitive?</p>
  
  <p>My query is </p>
  
  <pre><code>SELECT DISTINCT email FROM `jm_order`
  </code></pre>
  
  <p>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</p>
  
  <pre><code>sam@gmail.com
  josh@gmail.com
  Sam@gmail.com
  john@gmail.com
  </code></pre>
  
  <p>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 <code>sam@gmail.com</code> and <code>Sam@gmail.com</code> just because they are different cases?</p>