MySQL Regular Expression Functions

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

  1. NOT REGEXP

    The MySQL NOT REGEXP operator returns whether a string mismatches a regular expression.

  2. NOT RLIKE

    The MySQL NOT RLIKE operator returns whether a string mismatches a regular expression.

  3. REGEXP

    The MySQL REGEXP operator returns whether a string matches a regular expression.

  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

    The MySQL REGEXP_LIKE() function checks whether a string matches a regular expression.

  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

    The MySQL RLIKE operator returns whether a string matches a regular expression.