In MariaDB, ADDDATE() is a built-in date and time function that performs date arithmetic.
It allows you to change a date by specifying the date, the unit to add, and the amount to add. You can pass a negative amount if you need to subtract the date by a certain interval.
ADDDATE() also has a shortcut syntax that allows you to add a given number of days to the date.
In MariaDB, DATE_ADD() is a built-in date and time function that performs date arithmetic.
It allows you to change a date by specifying the date, the unit to add, and the amount to add. You can pass a negative amount if you need to subtract the date by a certain interval.
Continue readingIn MariaDB, the REGEXP_REPLACE() function replaces occurrences of the substring within a string that matches the given regular expression pattern.
The whole string is returned along with the replacements.
If there’s no match (i.e. the input string doesn’t contain the substring), the the whole string is returned unchanged.
Continue readingIn 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 readingIn 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.
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.
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.
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).
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.
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.