LTRIM_IN

Description

Syntax

VARCHAR ltrim_in(VARCHAR str[, VARCHAR rhs])

When there is no rhs parameter, remove the spaces that appear consecutively in the parameter str starting from the left part; when there is an rhs parameter, search and remove any characters in the rhs character set at the left end of the string (regardless of order)

Examples

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

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

Keywords

LTRIM_IN