Back to Starrocks

right

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

4.1.0500 B
Original Source

right

This function returns a specified length of characters from the right side of a given string. Length unit: utf8 character. Note: This function is also named as strright.

Syntax

SQL
VARCHAR right(VARCHAR str,INT len)

Examples

SQL
MySQL > select right("Hello starrocks",9);
+-----------------------------+
| right('Hello starrocks', 9) |
+-----------------------------+
| starrocks                   |
+-----------------------------+

keyword

RIGHT