In MariaDB, TRIM() is a built-in string function that removes characters from the start or end of a string.
By default it removes leading and trailing spaces, but you can specify which character to remove, as well as which side/s you’d like it removed from.
In MariaDB, RTRIM() is a built-in string function that returns a string with any trailing space characters removed.
In MariaDB, LTRIM() is a built-in string function that returns a string with any leading space characters removed.
In MariaDB, the LOAD_FILE() function reads a file and returns the file contents as a string.
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.
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.
In MariaDB, the LIKE operator allows you to do pattern matching. It determines whether a specific character string matches a specified pattern. It returns either 1 (TRUE) or 0 (FALSE).
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.