How can I remove the leading and trailing spaces both at once from a string by using MySQL LTRIM() and RTRIM() functions?

For removing both leading and trailing spaces at once from a string by using LTRIM() and RTRIM() functions, we must have to use one function as an argument for other function. In other words, we must have to pass either LTRIM() function as an argument of RTIM() function or vice versa. It can be understood from the following example −

Example

Suppose we have a table ‘test_trim’ having a column ‘Name’ containing the values with leading and trailing spaces both −

mysql> Select * from test_trim;
+---------------+
| Name          |
+---------------+
| Gaurav        |
| Rahul         |
| Aarav         |
+---------------+
3 rows in set (0.00 sec)

Now the following query will remove the leading and trailing spaces at once from the names by using LTRIM() and RTRIM() functions −

mysql> Select Name, LTRIM(RTRIM(Name))AS 'Name Without Spaces' from test_trim;
+---------------+---------------------+
| Name          | Name Without Spaces |
+---------------+---------------------+
| Gaurav        | Gaurav              |
| Rahul         | Rahul               |
| Aarav         | Aarav               |
+---------------+---------------------+
3 rows in set (0.00 sec)

mysql> Select Name, RTRIM(LTRIM(Name))AS 'Name Without Spaces' from test_trim;
+---------------+---------------------+
| Name          | Name Without Spaces |
+---------------+---------------------+
| Gaurav        | Gaurav              |
| Rahul         | Rahul               |
| Aarav         | Aarav               |
+---------------+---------------------+
3 rows in set (0.00 sec)

Manikanth Mani

Updated on 06-Feb-2020 06:49:58

• Related Questions & Answers
• How can I remove the leading and trailing spaces both at once from a string without using MySQL LTRIM() and RTRIM() functions?
• Trim (Remove leading and trailing spaces) a string in C#
• Trim a string in Java to remove leading and trailing spaces
• How to remove white spaces (leading and trailing) from string value in MongoDB?
• How MySQL LTRIM() and RTRIM()functions can be used with WHERE clause?
• How can we use the output of LTRIM() and RTRIM() functions to update MySQL table?
• Java Program to remove the leading and trailing quotes from a string
• Java Program to remove leading and trailing whitespace from a string
• How to remove leading and trailing whitespace from a MySQL field value?
• How can we eradicate leading and trailing space characters from a string in MySQL?
• How to remove leading and trailing whitespace in a MySQL field?
• How to remove all trailing and leading whitespace in a string in Python?
• MySQL query to remove trailing spaces
• Python Pandas – Remove leading and trailing whitespace from more than one column
• Remove trailing numbers surrounded by parenthesis from a MySQL column