strleft
Description
This function extracts a number of characters from a string with specified length (starting from left). The unit for length: utf8 character. Note: This function is also named as left.
Syntax
VARCHAR strleft(VARCHAR str,INT len)
Examples
MySQL > select strleft("Hello starrocks",5);
+-------------------------------+
| strleft('Hello starrocks', 5) |
+-------------------------------+
| Hello |
+-------------------------------+
keyword
STRLEFT