MySQL Left() or SUBSTRING()?
mysql, sql, substring
Solution
By itself there is little difference, however `left` can potentially utilize an index while `substring` cannot.
Problem
Both of these queries will produce same result. But which one is better, faster. ``` SELECT LEFT(textField, 100) AS first100Chars SELECT SUBSTRING(textField, 1, 100 ) ``` Thanks.