Sometimes you might find that the amount of text returned in a database column is too long. You might just want to return a short snippet of that text, followed by an ellipsis or three dots.
Fortunately, this is relatively easy to do in MariaDB.
MariaDB
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().
How LOCATE() Works in MariaDB
In MariaDB, LOCATE() is a built-in string function that returns the position of the first occurrence of a substring within another string.
LOCATE() is similar to the INSTR() function, except that LOCATE() provides the option of specifying a starting position for the search. Also, the argument order is reversed between these two functions.
How INSTR() Works in MariaDB
In MariaDB, INSTR() is a built-in string function that returns the position of the first occurrence of a substring within another string.
INSTR() is similar to the LOCATE() function, except that LOCATE() provides the option of specifying a starting position for the search. Also, the argument order is reversed between these two functions.
How the INSERT() Function Works in MariaDB
In MariaDB, INSERT() is a built-in string function that allows you to insert a substring into another string.
How UNHEX() Works in MariaDB
In MariaDB, UNHEX() is a built-in string function that performs the inverse operation of the HEX() function.
Whereas, the HEX() function returns a hexadecimal representation of a given string, the UNHEX() function returns the string representation of a given hexadecimal value.
Specifically, UNHEX() interprets each pair of hexadecimal digits in its argument as a number, and then converts it to the character represented by the number.
The result is returned as a binary string.
How HEX() Works in MariaDB
In MariaDB, HEX() is a built-in string function that returns a hexadecimal string representation of its argument.
How FORMAT() Works in MariaDB
In MariaDB, FORMAT() is a built-in string function that formats and returns the given number as a string.
It requires two arguments, and accepts an optional third argument. The first is the number you want to format, the second is the decimal position, and the (optional) third is the locale.
How FROM_BASE64() Works in MariaDB
In MariaDB, FROM_BASE64() is a built-in string function that decodes the given base-64 encoded string.
It returns the result as a binary string.