Prisma

how do you test for array inclusion; given a schema

```

model states {
    id                                   String @id
    hindexes                            String[]
    administrative_area_level           Int
    administrative_area_level_1         String
    administrative_area_level_2         String
}```
If I want to find all states that include a given string in hIndexes, what does the “where” look like?(postgres FWIW)

It seems you are looking for <https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#has|has> filter operator.
Can you have a look at it?

```  await prisma.states.findMany({
    where: {
      hindexes: {
        has: 'search_string',
      },
    },
  });```

:wave: Hello <@U03RZ41US00>, did you have a chance to see Nurul's comment? Let us know if that solution helps!