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.
Continue readingIn 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, the NOT LIKE operator is used to test whether or not a string does not match a pattern. It returns the inverse of the LIKE operator. It’s the same as applying the NOT operator against the whole LIKE expression.
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.
In MariaDB, UCASE() 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).
UCASE() is a synonym for UPPER().