📣
TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

RIGHT



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

Syntax

RIGHT(<str>, <len>);

Arguments

ArgumentsDescription
<str>The main string from where the character to be extracted
<len>The count of characters

Return Type

VARCHAR

Examples

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

Was this page helpful?