Description

Syntax

VARCHAR RIGHT (VARCHAR str, INT len)

It returns the right part of a string of specified length, length is char length not the byte size.

example

1. mysql> select right("Hello doris",5);
2. +-------------------------+
3. | right('Hello doris', 5) |
4. +-------------------------+
5. | doris                   |
6. +-------------------------+

keywords

1. RIGHT