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β
VARCHAR right(VARCHAR str,INT len)
Examplesβ
MySQL > select right("Hello starrocks",9);
+-----------------------------+
| right('Hello starrocks', 9) |
+-----------------------------+
| starrocks |
+-----------------------------+
keywordβ
RIGHT