Remove trailing spaces from a string:
SELECT RTRIM(“SQL Tutorial “) AS RightTrimmedString; |
The RTRIM() function eliminates trailing spaces from a string.
RTRIM(string) |
Parameter |
Description |
string |
Input required: The string from which trailing spaces will be removed. |
Works in: | From MySQL 4.0 |