gular
expression performance, and REGEXP_SUBSTR was introduced as part of this
enhancement.

The default_regex_flags variable addresses the remaining compatibilities
between PCRE and the old regex library.

Examples
--------

SELECT REGEXP_SUBSTR('ab12cd','[0-9]+');
-> 12

SELECT REGEXP_SUBSTR(
 'See https://mariadb.org/en/foundation/ for details',
 'https?://[^/]*');
-> https://mariadb.org

SELECT REGEXP_SUBSTR('ABC','b');
-> B

SELECT REGEXP_SUBSTR('ABC' COLLATE utf8_bin,'b');
->

SELECT REGEXP_SUBSTR(BINARY'ABC','b');
->

SELECT REGEXP_SUBSTR('ABC','(?i)b');
-> B

SELECT REGEXP_SUBSTR('ABC' COLLATE utf8_bin,'(?+i)b');
-> B

URL: https://mariadb.com/kb/en/regexp_substr/https://mariadb.com/kb/en/regexp_substr/