W3cubDocs

/MariaDB

Regular Expressions Functions

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
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 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/