Skip to main content
Skip to main content

ltrim

ltrim​

Description​

Syntax​

VARCHAR ltrim(VARCHAR str[, VARCHAR rhs])

When the 'rhs' parameter is not present, remove the continuous spaces that appear from the beginning of the 'str' parameter. Otherwise, remove 'rhs'.

example​

mysql> SELECT ltrim('   ab d');
+------------------+
| ltrim(' ab d') |
+------------------+
| ab d |
+------------------+

mysql> SELECT ltrim('ababccaab','ab') str;
+-------+
| str |
+-------+
| ccaab |
+-------+

keywords​

LTRIM