In MariaDB, the REGEXP operator is used to determine whether or not a string matches a regular expression.
If the string matches the regular expression provided, the result is 1, otherwise it’s 0.
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.