VeloDB Cloud
SQL Manual
Functions
string-functions
strleft

strleft

Description

Syntax:

VARCHAR STRAIGHT (VARCHAR str, INT len)

This function returns the left part of the specified length of a string. length is a UTF8 character.

Example

mysql> select strleft("Hello doris",5);
+------------------------+
| strleft('Hello doris', 5) |
+------------------------+
| Hello                  |
+------------------------+

Keywords

STRLEFT