1
Regular Expressions Functions
MariaDB 101: Learning the Basics of MariaDB
Watch the WebinarMariaDB includes a number of functions for dealing with regular expressions.
-
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.