MySQL Forums
Forum List  »  General

Advanced Search
New Topic

[RESOLVED]: LEFT() or SUBSTRING() to obtain the left character from a field
Posted by: Avera Solutions
Date: June 07, 2009 11:32AM

Okay, with regard to this I have read a small article on mysql.com and it basically says that the LEFT() function is specifically designed to do this.

SUBSTRING is slightly slower because it is designed to scan a string to find the starting character, as opposed to LEFT which always starts in the same place.

Avera Solutions Limited
Web Design & Hosting Services
Web Design
__________________
SEO Tactics Forum <- Join Today!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
LEFT() or SUBSTRING() to obtain the left character from a field
Avera Solutions
June 06, 2009 09:26AM
[RESOLVED]: LEFT() or SUBSTRING() to obtain the left character from a field
Avera Solutions
June 07, 2009 11:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.