RIGHT() - Last N Characters

Q

How to return last N characters from a given string using the RIGHT() function?

✍: FYIcenter.com

A

RIGHT(str, len) is a MySQL built-in function that returns the last N characters of a giving string. For example:

SELECT RIGHT('dba.FYIcenter.com', 3);
  -- +-------------------------------+
  -- | RIGHT('dba.FYIcenter.com', 3) |
  -- +-------------------------------+
  -- | com                           |
  -- +-------------------------------+

Reference information of the RIGHT() function:

RIGHT(str, len): substr
  Returns the rightmost len characters from the string str, or NULL
  if any argument is NULL.

Arguments, return value and availability:
  str: Required. The given string to be extracted from.
  len: Required. The number of characters of the substring.
  substr: Return value. The substring of last len characters.
  Available since MySQL 4.0.

Related MySQL functions:

 

RPAD() - Right-Padding String

REVERSE() - Reversing String

MySQL Functions on Character String Values

⇑⇑ MySQL Function References

2023-11-12, 212🔥, 0💬