MaldRunner
PPrisma
•Created by MaldRunner on 8/17/2024 in #help-and-questions
SqlServer $queryRaw with 'in' operator
hi, I have been stuck with trying to do $queryRaw using in operator
I have array like this
const arr = ['john', 'tony', 'sarah']
I'm trying to do select * from table where name in (${Prisma.join(arr)})
not returning any result, but if I hard code those values it works fine
when I do console log using array join without prisma join it returned "/'john/',/'tony/',/'sarah/'", might be the problem here ?
the example in docs are for integers not strings
thanks in advance1 replies