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.
Tag: what is
How UPDATEXML() Works in MariaDB
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.
How WEIGHT_STRING() Works in MariaDB
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.
How UNCOMPRESSED_LENGTH() Works in MariaDB
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.
How COMPRESS() Works in MariaDB
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.
How UNCOMPRESS() Works in MariaDB
In MariaDB, UNCOMPRESS() is a built-in function that uncompresses a string that’s been compressed by the COMPRESS() function.
How STRCMP() Works in MariaDB
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.
How SPACE() Works in MariaDB
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.
Continue readingHow SOUNDS LIKE Works in MariaDB
In MariaDB, you can use SOUNDS LIKE in a query to match words that sound alike.
How SOUNDEX() Works in MariaDB
In MariaDB, SOUNDEX() is a built-in string function that returns the Soundex string from a given string.
Soundex is a phonetic algorithm for indexing names by sound, as pronounced in English. If two words sound the same, they should have the same Soundex string. If two words sound similar, but not exactly the same, their Soundex string might look similar but not exactly the same.
The function accepts one argument: the string for which to return the Soundex string from.
Continue reading