SQL
Text Functions and Operators
<div class="nostroke_table"></div>  
|   |   |
|:--|:--------|
| **Description** |Splits the `string` along the `regex` and returns a row for each part. |
| **Example** | `regexp_split_to_table('hello world; 42', ';? ')` |
| **Result** | Two rows: `'hello'`, `'world'` |