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, 245🔥, 0💬
Popular Posts:
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...