left

This function returns a specified number of characters from the left side of a given string. The unit for length: utf8 character. Note: This function is also named as strleft.

Syntax

SQL

VARCHAR left(VARCHAR str,INT len)

Examples

SQL

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

keyword

LEFT