title: What is the fastest case sensitive string comparision in MySQL?
body: <p>I want to join two tables on a char column. The simplest way I use is:</p>
  
  <pre><code>SELECT * FROM a JOIN b ON (a.text = b.text)
  </code></pre>
  
  <p>This method is quite fast but it the comparison of field is case insensitive. I have tried <code>STRCMP(.., ..)</code> and <code>.. LIKE ..</code> instead <code>.. = ..</code> but both are far to slow. What is the best solution to join two tables on char column with respect to the letter case?</p>