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

# sql_like

> Filters string fields using SQL LIKE pattern matching with wildcards.

Filters string fields using `SQL LIKE` pattern matching with wildcards. Returns rows where the field value matches the specified pattern using SQL LIKE syntax.

Can be used with [`case_insensitive`](/modeling/filters/operators/case-insensitive) to perform case-insensitive matching.

<Note>
  To create this filter in a workbook, use the **is like** operator.
</Note>

## Syntax

```yaml theme={null}
<string_field>:
  sql_like: <pattern>
```

## Properties

<ParamField path="string_field" type="object[]">
  The string field to filter on, specified in the format `view_name.field_name`.

  <Expandable title="string_field properties" defaultOpen="true">
    <ParamField path="sql_like" type="string" required>
      The pattern to match using SQL LIKE syntax. Use `%` to match any sequence of characters and `_` to match a single character.
    </ParamField>

    <ParamField path="case_insensitive" type="boolean" default="false">
      When set to `true`, performs case-insensitive matching. Defaults to `false` (case-sensitive) if omitted.
    </ParamField>
  </Expandable>
</ParamField>

## Examples

```yaml title="Matches names containing both 'Adel' and 'Vargas' in that order" theme={null}
users.name:
  sql_like: '%Adel%Vargas%'
```

```yaml title="Matches products starting with 'prod' and ending with any 3 characters" theme={null}
products.sku:
  sql_like: 'prod___'
```

```yaml title="Matches email addresses from gmail.com (case-insensitive)" theme={null}
users.email:
  sql_like: '%@gmail.com'
  case_insensitive: true
```