RIGHT(str,len)

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

Syntax

MYSQL Copy

SELECT RIGHT('foobarbar', 4);
'rbar'

Examples

Example

This function is multibyte safe.

MYSQL Copy

SELECT RIGHT('foobarbar', 4);
'rbar'