MySQL8 TRIM() Functions – String Functions

by · Published · Updated

MySQL TRIM() Functions: Syntax

TRIM([{BOTH | LEADING | TRAILING} [removestring] FROM] string1);
OR
TRIM([removestring FROM] string1);

MySQL TRIM() Functions: Description

TRIM() functions removes all leading i.e from the front and trailing i.e in the end, spaces or prefixes or suffixes from the input string. If none of the specifiers BOTH, LEADING, or TRAILING is given, BOTH is used as default.

  • LEADING – This option will delete the spaces or specified string from the front of the input string.
  • TRAILING – This option will delete the spaces or specified string from the end of the input string.
  • BOTH – This option will delete the spaces or specified string from the front and end of the input string.

removestring is Optional. It removes the specific string if specified in the query.

Note : This function is multibyte safe.

MySQL TRIM() Functions: Parameter

[table caption=”” width=”100%” colwidth=”15%|30%|55%” colalign=”left|left|left”]
Name, Required /Optional, Description
string1, Required, Input string is must.
Specifiers, Optional, If none of the specifiers BOTH or LEADING or TRAILING is given. BOTH is used as default.
removestring, Optional, It removes the removestring if specified in the query.
[/table]

MySQL TRIM() Functions: Output

[table caption=”” width=”100%” colwidth=”20%|80%” colalign=”left|left”]
Returns, trimmed string.
[/table]

MySQL TRIM() Functions: Available from

[table caption=”” width=”100%” colwidth=”25%|75%” colalign=”left|left”]
Version, MySQL 4.0
[/table]

MySQL TRIM() Functions: Example 1

mysql> SELECT TRIM(LEADING 'x' FROM 'xxxTutsxxx');
+-------------------------------------------------+
| TRIM(LEADING 'x' FROM 'xxxTutsxxx') |
+-------------------------------------------------+
| Tutsxxx                               |
+------------------------------------+
1 row in set (0.00 sec)

MySQL TRIM() Functions: Example 2

mysql>  SELECT TRIM(BOTH 'x' FROM 'xxxTutsxxx');
+------------------------------------+
| TRIM(BOTH 'x' FROM 'xxxTutsxxx') |
+------------------------------------+
| Tuts                              |
+------------------------------------+

MySQL TRIM() Functions: Example 3

mysql>  SELECT TRIM(TRAILING 'x' FROM 'xxxTutsxxx');
+------------------------------------+
| TRIM(TRAILING 'x' FROM 'xxxTutsxxx') |
+------------------------------------+
| xxxTuts                              |
+------------------------------------+
1 row in set (0.00 sec)

See all MySQL String functions MySQL 8 String Functions.

Related articles : CONCAT(), CONCAT_WS() , LOWER(), UPPER(), LTRIM(), RTRIM().

PHP Related articles : TRIM(), LTRIM(), RTRIM(), PHP STRING FUNCTIONS().

You may also like...