Topics

inArray() using sql`` operator in JS and Postgres

kornel · 2023-11-03T07:31:45.457Z

Hey, how do I use sql operator with arrays in JS? ```javascript const array = [1,2,3]; const sqlQuery = sql`${users.id} IN ???`; ```

Hey, how do I use sql operator with arrays in JS?

const array = [1,2,3];
const sqlQuery = sql`${users.id} IN ???`;

const array = [1,2,3];
const sqlQuery = sql`${users.id} IN ???`;

2 Replies

karadz.•2y ago

const sqlQuery = sql${users.id} IN ${array}

kornelOP•2y ago

🤦 I tried to use it on column that type is array, that's why I had a problem. Thanks.

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

11KMembers