SingleStore DB

LTRIM

Removes leading space characters from the given string.

Syntax
LTRIM (str)
Arguments
  • str: any string or binary object

Return Type

String

Examples

Notice

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      |
+----------+-----------+