The 10.6.0 release of MariaDB has added a JSON_TABLE() function.
The JSON_TABLE() function returns a representation of a JSON document as a relational table with the specified columns. It enables you to map JSON paths into relational columns to be returned in its results set.
In MariaDB, UPDATEXML() is a built-in function that replaces a single portion of a given fragment of XML markup with a new XML fragment, then returns the updated XML.
In MariaDB, WEIGHT_STRING() is a built-in function that returns the weight string for the input string. The return value is a binary string that represents the comparison and sorting value of the string.
In MariaDB, UNCOMPRESSED_LENGTH() is a built-in function that returns the length of a compressed string before it was compressed with the COMPRESS() function.
In MariaDB, COMPRESS() is a built-in function that compresses a string and returns the result as a binary string.
The COMPRESS() function requires MariaDB to have been compiled with a compression library such as zlib. If MariaDB hasn’t been compiled with such a compression library, COMPRESS() returns null.
In MariaDB, UNCOMPRESS() is a built-in function that uncompresses a string that’s been compressed by the COMPRESS() function.
In MariaDB, STRCMP() is a built-in string function that compares two strings. It returns 0, -1, or 1, depending on whether the strings are the same or not.
In MariaDB, SPACE() is a built-in string function that returns a given number of space characters.
You provide the number of spaces to return when you call the function.
In MariaDB, you can use SOUNDS LIKE in a query to match words that sound alike.