MySQL TRIM Function

Overview

In this tutorial, we will learn about MySQL TRIM function with some examples. This function removes the trim character/string from the beginning or at the end of the given string.

Syntax

The general syntax of the function is as follows:

TRIM([LEADING | TRAILING | BOTH <trim_string> FROM ] <string>)

Examples

mysql> SELECT TRIM(‘ MySQL Tutorials ‘);
+—————————————————+
| TRIM(‘ MySQL Tutorials ‘) |
+—————————————————+
| MySQL Tutorials |
+—————————————————+
1 row in set (0.00 sec)

mysql> SELECT TRIM(LEADING ‘a’ FROM ‘aaaaMySQL Tutorials’);
+———————————————-+
| TRIM(LEADING ‘a’ FROM ‘aaaaMySQL Tutorials’) |
+———————————————-+
| MySQL Tutorials |
+———————————————-+
1 row in set (0.01 sec)

MySQL TRIM Function Example