# REGEXP

```
REGEXP(strExpr, regexExpr)
```

Returns the matched groups otherwise null.

Available in:

| Processors | SQL Studio |
| ---------- | ---------- |
| ✓          | ✓          |

*Sample code:*

```sql
USE `kafka`;
SELECT 
    REGEXP(first_name,'Jo'), 
    first_name 
FROM users-topic
LIMIT 3;
```

*Output:*

```json
{
  "value": {
    "REGEXP": [
      "Jo"
    ],
    "first_name": "Jose"
  }
}
{
  "value": {
    "REGEXP": [
      "Jo"
    ],
    "first_name": "Joshua"
  }
}
{
  "value": {
    "REGEXP": [],
    "first_name": "Kathleen"
  }
}
```