title: MySQL Left() or SUBSTRING()?
body: <p>Both of these queries will produce same result. But which one is better, faster.</p>
  
  <pre><code>SELECT LEFT(textField, 100) AS first100Chars
  
  SELECT SUBSTRING(textField, 1, 100 )
  </code></pre>
  
  <p>Thanks.</p>