In MariaDB, LTRIM() is a built-in string function that returns a string with any leading space characters removed.
string functions
How LOAD_FILE() Works in MariaDB
In MariaDB, the LOAD_FILE() function reads a file and returns the file contents as a string.
How RPAD() Works in MariaDB
In MariaDB, RPAD() is a built-in string function that pads the right part of a string with a certain number of a specified character.
For example, you can use RPAD() to pad the right part of a string with dots.
How LPAD() Works in MariaDB
In MariaDB, LPAD() is a built-in string function that pads the left part of a string with a certain number of characters.
For example, you can use LPAD() to pad the left part of a string with spaces. Or you could pad a number with leading zeros.
How RIGHT() Works in MariaDB
In MariaDB, RIGHT() is a built-in string function that returns a given number of characters from the rightmost part of a string.
RIGHT() accepts two arguments; the string, and the number of characters to return from the right part of that string.
How UPPER() Works in MariaDB
In MariaDB, UPPER() is a built-in string function that returns its string argument with all characters changed to uppercase.
The result is returned in the current character set mapping. The default is latin1 (cp1252 West European).
Another MariaDB function, UCASE() is a synonym for UPPER().
How LEFT() Works in MariaDB
In MariaDB, LEFT() is a built-in string function that returns a given number of characters from the leftmost part of a string.
LEFT() accepts two arguments; the string, and the number of characters to return from the left part of that string.
How LOWER() Works in MariaDB
In MariaDB, LOWER() is a built-in string function that returns its string argument with all characters changed to lowercase.
The result is returned in the current character set mapping. The default is latin1 (cp1252 West European).
Another MariaDB function, LCASE() is a synonym for LOWER().