MySQL Left() or SUBSTRING()?

user_884588 0
Viewed 14362

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.

substring mysql sql
2 Answers

By itself there is little difference, however left can potentially utilize an index while substring cannot.

user_8411760

Substring will take little more time than left function. Though your case is straight forward use left function only.

user_26702470
Related