Menu

MySQL Regular Expression Functions

This page lists the Regular Expression functions and operators in MySQL.

  1. NOT REGEXP

    Use MySQL NOT REGEXP to select strings that do not match a pattern; NULL operands return NULL, not true.

  2. NOT RLIKE

    MySQL NOT RLIKE is a synonym for NOT REGEXP and selects strings that do not match a regular expression.

  3. REGEXP

    Use MySQL’s REGEXP operator to test a string against a regular expression; see its return values, collation behavior, and REGEXP_LIKE() alternative.

  4. REGEXP_INSTR

    The MySQL REGEXP_INSTR() function searches a string for a substring that match a specified regular expression and returns the index of the substring.

  5. REGEXP_LIKE

    Use MySQL REGEXP_LIKE() to test a string against a regular expression, control case sensitivity, and interpret match results.

  6. REGEXP_REPLACE

    The MySQL REGEXP_REPLACE() function replaces each substring of the text String that matches the given regular expression with the given replacement.

  7. REGEXP_SUBSTR

    The MySQL REGEXP_SUBSTR() function extracts a substring from a string that matches the specified regular expression and returns it.

  8. RLIKE

    MySQL RLIKE is a synonym for REGEXP; test string patterns with its operator syntax and review collation-sensitive matching.