Regular Expressions Functions

Learn about regular expression functions in MariaDB Server. This section details SQL functions for powerful pattern matching and manipulation of string data using regular expressions.

Regular Expressions Overview

Get an overview of regex usage. This page introduces the pattern matching capabilities and common metacharacters used in MariaDB regular expressions.

PCRE - Perl Compatible Regular Expressions

Understand MariaDB's regex support. This concept page explains the PCRE library integration, detailing supported syntax, character classes, and special characters.

REGEXP

Complete REGEXP operator reference: expr REGEXP/RLIKE pat syntax, 1/0/NULL return values, NOT REGEXP aliases, BINARY case-sensitivity, default_regex_flags.

NOT REGEXP

Negated regular expression matching. This operator tests whether a string does NOT match a specified regular expression pattern.

REGEXP_INSTR

Return the index of a regex match. This function finds the starting position of the first substring that matches the given pattern.

REGEXP_REPLACE

Replace regex matches in a string. This function substitutes occurrences of a pattern with a specified replacement string.

REGEXP_SUBSTR

Return the substring matching a regex. This function extracts the actual part of the string that matches the given pattern.

RLIKE

Synonym for REGEXP. This operator performs a regular expression match against a string argument.

_{This page is licensed: CC BY-SA / Gnu FDL}