Collections:
RIGHT() - Last N Characters
How to return last N characters from a given string using the RIGHT() function?
✍: FYIcenter.com
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, 212🔥, 0💬
Popular Posts:
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...