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?

Ben · Accepted Answer · 2020-07-25 15:48:04Z

18

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

edited Jul 25, 2020 at 15:48

Ben

57.6k50 gold badges187 silver badges229 bronze badges

answered Jan 20, 2016 at 9:47

asbel

2042 silver badges5 bronze badges

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

Comments

Glowin · Accepted Answer · 2021-07-03 18:27:04Z

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 3, 2021 at 18:27

Glowin

5,0161 gold badge18 silver badges10 bronze badges

Comments

Jurass · Accepted Answer · 2025-06-16 08:18:17Z

0

The answers looks more complicated than this recommended SQLite solution:

db.all('SELECT email ' +
       'FROM users' +
       'WHERE email IN (SELECT value FROM json_each(?))', 
       JSON.stringify(friends), 
       function(err, rows) {
           if (!err) {

Actually, the existence of function:

SELECT value FROM json_each(?)

Could be that reason, why SQlite still doesn't support passing array as parameter.

answered Jun 16 at 8:18

Jurass

6161 gold badge9 silver badges20 bronze badges

Collectives™ on Stack Overflow

Node.js sqlite3 IN operator

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related