RIGHT()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns the requested number of rightmost characters in a string.
USAGE
RIGHT(string, count)
Argument Name | Description |
|---|---|
| The source string |
| The number of characters to return |
DETAILS
RIGHT() is a string function that returns the requested number of rightmost characters in the string argument.
If the count exceeds the length of the string, the entire string is returned without any padding.
A NULL is returned if either argument is NULL.
EXAMPLES
SELECT RIGHT('MariaDB!', 3);
+----------------------+
| RIGHT('MariaDB!', 3) |
+----------------------+
| DB! |
+----------------------+
SELECT QUOTE(RIGHT('hi', 10));
+------------------------+
| QUOTE(RIGHT('hi', 10)) |
+------------------------+
| 'hi' |
+------------------------+