TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str), TRIM([remstr FROM] str) : TRIM : String Functions MySQL TUTORIALS

MySQL TUTORIALS » String Functions » TRIM »

TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str), TRIM([remstr FROM] str)

Returns the string str with all remstr prefixes or suffixes removed.

If none of the specifiers BOTH, LEADING, or TRAILING is given, BOTH is assumed.

remstr is optional and, if not specified, spaces are removed.


mysql>
mysql>
mysql> SELECT TRIM('  navioo   ');
+---------------------+
| TRIM('  navioo   ') |
+---------------------+
| navioo              |
+---------------------+
1 row in set (0.00 sec)

mysql>

Related Scripts with Example Source Code in same category :

TRIM(LEADING 'x' FROM 'xxxhava2sxxx');
TRIM(BOTH 'x' FROM 'xxxjava2sxxx');
TRIM(TRAILING 'xyz' FROM 'java2sxxyz');
The TRIM() function can trim spaces and characters or groups of characters.
SELECT TRIM(LEADING 'XXX' FROM 'XXXFileName')
If you wanted to trim leading and trailing characters, you would use the keyword BOTH

MySQL TUTORIALS

String Functions
» TRIM

Aggregate Functions

Cast Functions Operators

Comparison Functions Operators

Control Flow Functions

Cursor

Data Dictionary

Data Types

Database

Date Time Functions

Encryption Compression Functions

Information Functions

Insert Update Delete

Introduction

Logic Operator

Math Numeric Functions

Miscellaneous Functions

Privilege

Subquery

Table

Table Join

Trigger

View

TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str), TRIM([remstr FROM] str) : TRIM : String Functions MySQL TUTORIALS

MySQL TUTORIALS » String Functions » TRIM »

TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str), TRIM([remstr FROM] str)

Leave a Comment / Note

MySQL TUTORIALS