Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
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 |
+----------+-----------+
