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.

Continue reading →

In MariaDB, HEX() is a built-in string function that returns a hexadecimal string representation of its argument.

Continue reading →

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 reading →

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 reading →

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 reading →

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 reading →