if i have an array of primary keys, how

if i have an array of primary keys, how do i search using IN?
will this work? or do i need to format the array to a comma delimited string?

            const { results: usersFromUserIds } = await this.env.DB.prepare(

            const { results: usersFromUserIds } = await this.env.DB.prepare(

SELECT *
FROM user
WHERE _id IN (?1)


            )
                .bind(uniqueUserIds)
                .all()


            )
                .bind(uniqueUserIds)
                .all()

Gagan SuieOP•1/10/24, 11:51 PM

solved it by doing something like:

// Generate placeholders
let placeholders = activeUserIds.map((_, index) => '?' + (index + 1)).join(',')

// Use placeholders in the query and bind values
const { results: guests } = await this.env.DB.prepare(

)
.bind(...activeUserIds)
.all()