In MariaDB, the REGEXP_SUBSTR() function returns the substring that matches the given regular expression pattern.
If there’s no match (i.e. the input string doesn’t contain the substring), the result is an empty string.
Continue readingTag: functions
How REGEXP_INSTR() Works in MariaDB
In MariaDB, the REGEXP_INSTR() function returns the starting index of a substring that matches the regular expression pattern.
The index starts at 1. If there’s no match, the result is 0.
How NOT RLIKE Works in MariaDB
In MariaDB, NOT RLIKE is a negation of the RLIKE operator.
In other words, any time the RLIKE operator would return 1, NOT RLIKE will return 0.
How RLIKE Works in MariaDB
In MariaDB, the RLIKE operator is used to determine whether or not a string matches a regular expression. It’s a synonym for REGEXP.
If the string matches the regular expression provided, the result is 1, otherwise it’s 0.
How NOT REGEXP Works in MariaDB
In MariaDB, the NOT REGEXP operator is a negation of the REGEXP operator.
If the string matches the regular expression provided, the result is 0, otherwise it’s 1. This is the opposite result to what the REGEXP would return (when it isn’t prefixed with NOT).
How REGEXP Works in MariaDB
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.
MariaDB Introduces a JSON_TABLE() Function
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.
MariaDB to Introduce TO_CHAR()
The TO_CHAR() function has beeen introduced in MariaDB 10.6.1.
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.