Skip to main content
Version: 3.3

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

Rocky the happy otterStarRocks Assistant

AI generated answers are based on docs and other sources. Please test answers in non-production environments.