Skip to main content
Version: 2.5

left

Description​

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​

VARCHAR left(VARCHAR str,INT len)

Examples​

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

keyword​

LEFT