LTRIM
Removes all occurrences of any character present in the specified trim string from the left side of the string.
See also:
Analyze Syntax
func.ltrim(<string>, <trim_string>)
Analyze Examples
func.ltrim('xxdatabend', 'x')
+--------------------------------+
| func.ltrim('xxdatabend', 'x') |
+--------------------------------+
| databend |
+--------------------------------+
SQL Syntax
LTRIM(<string>, <trim_string>)
SQL Examples
SELECT LTRIM('xxdatabend', 'xx'), LTRIM('xxdatabend', 'xy');
┌───────────────────────────────────────────────────────┐
│ ltrim('xxdatabend', 'xx') │ ltrim('xxdatabend', 'xy') │
├───────────────────────────┼───────────────────────────┤
│ databend │ databend │
└───────────────────────────────────────────────────────┘