Skip to main content
Version: 2.5

strright

Description

This function extracts a number of characters from a string with specified length (starting from right). The unit for length: utf-8 character. Note: This function is also named as right.

Syntax

VARCHAR strright(VARCHAR str,INT len)

Examples

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

keyword

STRRIGHT