how to do ANY - Drizzle Team

Tthdxr

4/14/2023

need to do where 'myvariable' = ANY(mycolumn)

Bbloberenober

4/14/2023

.where(sql`'myvariable' = ANY(${mycolumn})`)

ASAndrii Sherman

4/14/2023

I guess myvariable also should be in ${}

Bbloberenober

4/14/2023

.where(sql`${myvariable} = ANY(${mycolumn})`)

Tthdxr

4/14/2023

yeah that's what I did but was wondering if there was a more native way

Tthdxr

4/14/2023

got it

Bbloberenober

4/14/2023

you can make a helper function

Tthdxr

4/14/2023

oh true