strleft

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

SQL

VARCHAR strleft(VARCHAR str,INT len)

Examples

SQL

MySQL > select strleft("Hello starrocks",5);
+-------------------------------+
| strleft('Hello starrocks', 5) |
+-------------------------------+
| Hello                         |
+-------------------------------+

keyword

STRLEFT