MariaDB includes a number of functions for dealing with regular expressions.
| Title | Description |
|---|---|
| Regular Expressions Overview | Regular Expressions allow MariaDB to perform complex pattern matching on a string. |
| PCRE - Perl Compatible Regular Expressions | PCRE (Perl Compatible Regular Expressions) for enhanced regular expressions. |
| NOT REGEXP | Same as NOT (expr REGEXP pat). |
| REGEXP | Performs pattern matching |
| REGEXP_INSTR | Position of the first appearance of a regex |
| REGEXP_REPLACE | Replaces all occurrences of a pattern |
| REGEXP_SUBSTR | Returns the matching part of a string |
| RLIKE | Synonym for REGEXP |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/regular-expressions-functions/