how to do ANY

need to do where 'myvariable' = ANY(mycolumn)
6 Replies
Dan
Dan2y ago
.where(sql`'myvariable' = ANY(${mycolumn})`)
Andrii Sherman
I guess myvariable also should be in ${}
Dan
Dan2y ago
.where(sql`${myvariable} = ANY(${mycolumn})`)
thdxr
thdxrOP2y ago
yeah that's what I did but was wondering if there was a more native way got it
Dan
Dan2y ago
you can make a helper function
thdxr
thdxrOP2y ago
oh true
Want results from more Discord servers?
Add your server