SQL
Text Functions and Operators
<div class="nostroke_table"></div>  
|   |   |
|:--|:--------|
| **Description** |If `string` contains the regexp `pattern`, returns the capturing group specified by optional parameter `group` (see [Pattern Matching](#docs:sql:functions:pattern_matching::using-regexp_extract)). |
| **Example** | `regexp_extract('hello_world', '([a-z ]+)_?', 1)` |
| **Result** | `hello` |