Prisma filter variable in given array
I have an array position:["GK","CDM","CF"]
and I have a
model Player {
id Int @id @default(autoincrement())
name String
age Int?
position String?
}
I need to filter position field if it has any of the given positions in position array.
How should I do that?
I tried this way but it doesn't work
and I have a
model Player {
id Int @id @default(autoincrement())
name String
age Int?
position String?
}
I need to filter position field if it has any of the given positions in position array.
How should I do that?
I tried this way but it doesn't work
