CODEWITHSUNDEEP
sqlnode.js
KitKit
KitKit

Reputation: 9583

NodeJS: Query Database Command with Loop condition

I want to run a PostgreSQL database query command with condition OR to filter object by an ID Array.

var id_arr = [1, 2, 3]

Result I want to get:

SELECT * FROM auth_user WHERE id = 1 OR id = 2 OR id = 3

I tried but it gets syntax error:

var querydb = `SELECT * FROM auth_user WHERE ` + for (var i of id) { return id = i } + 'OR'

How can I write this code?

Upvotes: 0

Views: 54

Answers (1)

Todd
Todd

Reputation: 5454

Like this?

var ids = [1,2,3]
var querydb = `SELECT * FROM auth_user WHERE id IN (${ids})`;

Upvotes: 1

Related Questions