In MariaDB, HEX() is a built-in string function that returns a hexadecimal string representation of its argument.
Tag: functions
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.
Continue readingHow 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.
Continue readingHow TO_BASE64() Works in MariaDB
In MariaDB, TO_BASE64() is a built-in string function that converts its string argument to its base-64 encoded form.
The TO_BASE64() function returns its result as a character string in the connection character set and collation (see how to get your connection’s collation).
How EXPORT_SET() Works in MariaDB
In MariaDB, EXPORT_SET() is a built-in string function that returns a string that reflects the bits in the specified value. For every bit set in the specified value, you get an “on” string and for every bit not set in the value, you get an “off” string.
It accepts a minimum of three arguments, plus two optional arguments.
Continue readingHow FIND_IN_SET() Works in MariaDB
In MariaDB, FIND_IN_SET() is a built-in string function that returns the index position where the given pattern occurs in the specified string list.
It accepts two arguments. The first is the pattern you want to search for. The second argument is a string containing comma-separated values for which to match the pattern against.
Continue readingHow FIELD() Works in MariaDB
In MariaDB, FIELD() is a built-in string function that returns the index position of the string or number matching the specified pattern.
It accepts two or more arguments. The first is the pattern you want to search for. All subsequent arguments are the strings or numbers for which to match the pattern against.
Continue readingHow ELT() Works in MariaDB
In MariaDB, ELT() is a built-in string function that accepts a numeric argument, followed by a series of string arguments. It then returns the string that corresponds to the given numeric position provided by the first argument.
How CONCAT_WS() Works in MariaDB
In MariaDB, CONCAT_WS() is a built-in string function that stands for Concatenate With Separator.
CONCAT_WS() performs a string concatenation on its arguments, with the first argument being the separator for the remaining arguments.
Concatenation is the operation of joining two or more strings end-to-end.
CONCAT_WS() accepts two or more arguments (although providing just two arguments would result in nothing being concatenated, due to the first argument being the separator, and the second being a single string to be concatenated with… nothing else).
How CONCAT() Works in MariaDB
In MariaDB, CONCAT() is a built-in string function that performs a string concatenation on its arguments. It returns the string that results from concatenating its arguments.
Concatenation is the operation of joining two or more strings end-to-end.
CONCAT() accepts one or more arguments, all of which are returned as a single concatenated string.