Outdated Version
You are viewing an older version of this section. View current production version.
LTRIM
Removes leading space characters from the given string.
Syntax
LTRIM (str)
Arguments
- str: any string or binary object
Return Type
String
Examples
Info
This function removes only space " " characters. Other whitespace characters like tab \t, newline \n, etc are preserved. It is equivalent to TRIM(LEADING " " FROM str).
select rtrim(' ohai ') as r, ltrim(' ohai ') as l;
+----------+-----------+
| r | l |
+----------+-----------+
| ohai | ohai |
+----------+-----------+
Related Topics
