RIGHT

Returns the rightmost len characters from the string str, or NULL if any argument is NULL.

Syntax

RIGHT(str,len);

Arguments

Arguments	Description
str	The main string from where the character to be extracted
len	The count of characters

Return Type

String data type value.

Examples

SELECT RIGHT('foobarbar', 4);
+-----------------------+
| RIGHT('foobarbar', 4) |
+-----------------------+
| rbar                  |
+-----------------------+