How can we eradicate leading and trailing space characters from a string in MySQL?

MySQL LTRIM() and RTRIM() functions can be used to eradicate leading and trailing spaces from a string.

MySQL LTRIM() function is used to remove the leading space characters from a string. Its syntax can be as follows −

Syntax

LTRIM(String)

Here, String, is the string, passed as an argument, whose leading space characters are to be removed.

Example

mysql> Select LTRIM(' Hello');
+--------------------+
| LTRIM(' Hello')    |
+--------------------+
| Hello              |
+--------------------+
1 row in set (0.00 sec)

MySQL RTRIM() function is used to remove the trailing space characters from a string. Its syntax can be as follows −

Syntax

RTRIM(String)

Here, String, is the string, passed as an argument, whose trailing space characters are to be removed.

Example

mysql> Select RTRIM('Hello ');
+----------------------+
| RTRIM('Hello ')      |
+----------------------+
| Hello                |
+----------------------+
1 row in set (0.05 sec)

Sai Nath

Updated on 06-Feb-2020 06:51:53

• Related Questions & Answers
• Java Program to remove leading and trailing whitespace from a string
• How to remove leading and trailing whitespace from a MySQL field value?
• Java Program to remove the leading and trailing quotes from a string
• How to remove white spaces (leading and trailing) from string value in MongoDB?
• Trim (Remove leading and trailing spaces) a string in C#
• How to remove leading and trailing whitespace in a MySQL field?
• How can I remove the leading and trailing spaces both at once from a string by using MySQL LTRIM() and RTRIM() functions?
• How can I remove the leading and trailing spaces both at once from a string without using MySQL LTRIM() and RTRIM() functions?
• Trim a string in Java to remove leading and trailing spaces
• How can I eradicate some specific suffix or prefix or both from a MySQL string?
• How to remove all trailing and leading whitespace in a string in Python?
• Remove newline, space and tab characters from a string in Java
• How can we extract a substring from a string in MySQL?
• For each element in a Numpy array, return a copy with the leading and trailing characters removed
• How can we escape special characters in MySQL statement?