Outdated Version
You are viewing an older version of this section. View current production version.
TRIM
Removes padding from the ends of the given string.
Syntax
TRIM ([[BOTH | LEADING | TRAILING] [padding] FROM] str)
Arguments
- padding: any string or binary object (optional, defaults to " “)
- str: any string or binary object
If no keyword is specified, defaults to BOTH.
Return Type
String
Examples
Info
This function removes only space " " characters. Other whitespace characters like tab \t, newline \n, etc are preserved.
select trim(' ohai ') as t,
-> trim(LEADING FROM ' ohai ') as l,
-> trim(TRAILING FROM ' ohai ') as r;
+------+-----------+----------+
| t | l | r |
+------+-----------+----------+
| ohai | ohai | ohai |
+------+-----------+----------+
select trim("abra" FROM "abracadabra") as t;
+------+
| t |
+------+
| cad |
+------+
Related Topics
