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.
Removes leading space characters from the given string.
LTRIM (str)
String
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 |
+----------+-----------+