NodeJS: Query Database Command with Loop condition

Question

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?

Todd · Accepted Answer · 2018-10-02 09:37:43Z

1

Like this?

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

answered Oct 2, 2018 at 9:37

Todd

5,4843 gold badges33 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1