Back to Starrocks

strleft

docs/en/sql-reference/sql-functions/string-functions/strleft.md

4.1.0528 B
Original Source

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