Collections:
RTRIM() - Right-Trimming String
How to trim off space characters from a string at the right end using the RTRIM() function?
✍: FYIcenter.com
RTRIM(str) is a MySQL built-in function that trims off space characters from a string at the right end. For example:
SET @str = 'dba.FYIcenter.com '; SELECT RTRIM(@str); -- +-------------------+ -- | RTRIM(@str) | -- +-------------------+ -- | dba.FYIcenter.com | -- +-------------------+
Reference information of the RTRIM() function:
RTRIM(str): modstr Returns the string str with trailing space characters removed. Returns NULL if str is NULL. Arguments, return value and availability: str: Required. The string that will be right-trimmed from. modstr: Return value. The modified string after trimming. Available since MySQL 4.0.
Related MySQL functions:
⇒ SOUNDEX() - Soundex Encoding
⇐ RPAD() - Right-Padding String
2023-11-11, 239🔥, 0💬
Popular Posts:
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...