> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.
## Submitting Feedback
If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:
POST https://docs.firebolt.io/feedback
```json
{
"path": "/reference-sql/functions-reference/string/regexp-like",
"feedback": "Description of the issue"
}
```
Only submit feedback when you have something specific and actionable to report.
> Reference material for REGEXP_LIKE function
# REGEXP_LIKE
Checks whether a text pattern matches a regular expression string. Returns a `BOOLEAN` value, specifically `false` if the text doesn’t match and `true` if it does match. This is a RE2 regular expression.
## Syntax
```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
REGEXP_LIKE(, ''[,'[...]'])
```
## Parameters
| Parameter | Description | Supported input types |
| :------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `` | The text searched for a match using the RE2 pattern. | `TEXT` |
| `` | An RE2 regular expression pattern used to search for a match in the ``. | [RE2 regular expression](https://github.com/google/re2/wiki/Syntax) |
| `` | Optional. Flags allow additional controls over the regular's expression matching behavior. If using multiple flags, you can include them in the same single-quote block without any separator character. | Firebolt supports the following RE2 flags to override default matching behavior. With `-` in front you can disable the flag.
\* `i` - Specifies case-insensitive matching.
\* `m` - Specifies multi-line mode. In this mode, `^` and `$` characters in the regex match the beginning and end of line.
\* `s` - (Enabled per default) Specifies that the `.` metacharacter in regex matches the newline character in addition to any character in `.`
\* `U` - Specifies non-greedy mode. In this mode, the meaning of the metacharacters `*` and `+` in regex `` are swapped with `*?` and `+?`, respectively. See the examples using flags below for the difference in how results are returned. |
## Return Type
`BOOLEAN`
## Example
```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
REGEXP_LIKE('123','[a-z]');
```
**Returns**: `false`
```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
REGEXP_LIKE('123','\d+');
```
**Returns**: `true`
## Example using flags
The `i` flag causes the regular expression to be case-insensitive. Without this flag, this query would return `false` as no match is found.
```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
REGEXP_LIKE('ABC', '[a-z]', 'i');
```
**Returns**: `true`