right

Description

Syntax

VARCHAR RIGHT (VARCHAR STR)

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. +-------------------------+

keyword

RIGHT