title: Case insensitive search (and order by case insensitively) in a case-sensitive column
body: <p>I have a case-sensitive colume(utf8_bin collation). 
  I need to search a string case-insensitively and order the results case-insensitively.</p>
  
  <p>Is have written this query.</p>
  
  <pre><code>SELECT customer_name 
     FROM customers
     WHERE CONVERT(customer_name USING UTF8) LIKE 'aB%' 
     ORDER BY CONVERT(customer_name USING UTF8) 
     LIMIT 0,10
  </code></pre>
  
  <p>Is this efficient? Or is there a better way to achieve this? </p>