Outdated Version

You are viewing an older version of this section. View current production version.

RIGHT

Extracts the specified number of characters from the right end of a string

Syntax

RIGHT(str, len)

Arguments

  • str: any string or binary object
  • len: the number of characters to be extracted

Return Type

String

Examples

select right("1234567", 3);
+---------------------+
| right("1234567", 3) |
+---------------------+
| 567                 |
+---------------------+

Related Topics