left
Description
Syntax:
VARCHAR left (VARCHAR str, INT len)
This function returns the left part of the specified length of a string. length is a UTF8 character.
Example
mysql> select left("Hello doris",5);
+------------------------+
| left('Hello doris', 5) |
+------------------------+
| Hello |
+------------------------+Keywords
LEFT