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
2023-11-12, 1167🔥, 0💬
Related Topics:
