Node.js sqlite3 IN operator

Question

So I am currently trying to make a query in Node.js:

// friends is an array object
db.all('SELECT email ' +
       'FROM users' +
       'WHERE email in ?', friends, function(err, rows) {
           if (!err) {

I know that you can pass in an array of parameters for every '?' symbol, but is it possible to use the IN operator in this case? If not, should I do string concatenation or prepared statements?

score 17 · Accepted Answer · edited Jul 25 '20 at 15:48

17

db.all('SELECT email ' +
       'FROM users' +
       'WHERE email in ( ' + friends.map(function(){ return '?' }).join(',') + ' )', 
       friends, 
       function(err, rows) {
           if (!err) {

edited Jul 25 '20 at 15:48

Ben

54,723
49
178
224

answered Jan 20 '16 at 09:47

asbel

194
1
5

score 0 · Answer 2 · answered Jul 03 '21 at 18:27

0

// friends is an array object
db.all(`SELECT email FROM users WHERE email in ${ friends.map(() => "?").join(",") }`,
    friends, (err, rows) => {
    if (!err) {}
})

answered Jul 03 '21 at 18:27

Glowin

4,906
1
16
10

Node.js sqlite3 IN operator

2 Answers2

Linked