> ## Documentation Index
> Fetch the complete documentation index at: https://docs.e6data.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Regular expression functions

> Match, extract and replace text with regular expressions.

Match, extract and replace text with regular expressions.

| Function | Type | What it does |
| - | - | - |
| [`regexp_contains`](/query/sql/functions/regex/regexp_contains) | Scalar | Tests whether a regular expression matches any part of a string. |
| [`regexp_count`](/query/sql/functions/regex/regexp_count) | Scalar | Counts nonoverlapping matches of a regular expression in a string. |
| [`regexp_extract`](/query/sql/functions/regex/regexp_extract) | Scalar | Returns the selected capture group from the first regular-expression match. |
| [`regexp_extract_all`](/query/sql/functions/regex/regexp_extract_all) | Scalar | Returns the selected capture group from each regular-expression match. |
| [`regexp_like`](/query/sql/functions/regex/regexp_like) | Scalar | Tests whether a regular expression matches any part of a string. |
| [`regexp_replace`](/query/sql/functions/regex/regexp_replace) | Scalar | Replaces every regular-expression match in a string. |
| [`regexp_substr`](/query/sql/functions/regex/regexp_substr) | Scalar | Returns the first substring matching a regular expression. |
| [`rlike`](/query/sql/functions/regex/rlike) | Scalar | Tests whether a regular expression matches any part of a string. |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.