Question, is there a way to use

in

in the where clause of a query where the column data type is a

string

which values are like

1,2

? Like

prisma.model.findMany({ where: { col: { in: [1, 2] } } })

@Salvador Lopez Mendoza 👋 Nope,

in

is for total separate values and not for values inside the same string. For that, you might want to look into Full Text Search.

Thats the thing, the current database is using mysql and can’t use full text search, will have to make a migration. Thanks for the help anyway!