right syntax for IN (sql nodejs)

Question

Hi everyone so I try to use the IN sql command in sql node js plugin. I try a lot of syntax but all doesn't work. Can you help me ?

Thanks

Code :

var arr = log1.map( function(el) { return el.token; });

con.query( 'SELECT Nomfamille,prenomutilisateur FROM utilisateurs WHERE idpublic  IN = ' + arr.join() + '',  function (error, results, fields) {

another syntax :

 con.query( 'SELECT Nomfamille,prenomutilisateur FROM utilisateurs WHERE idpublic  IN = (' + arr.join() + ')',  function (error, results, fields) {

and :

con.query( 'SELECT Nomfamille,prenomutilisateur FROM utilisateurs WHERE idpublic  IN =  ?  ', [arr.join()] function (error, results, fields) {

the error :

Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= 23246,18200' at line 1

Possible duplicate of Pass array in Mysql query with nodejs

luksch
– luksch

2018-04-13 16:56:39 +00:00
Commented Apr 13, 2018 at 16:56 — luksch
– luksch, Commented Apr 13, 2018 at 16:56

ScaisEdge · Accepted Answer · 2018-04-13 16:59:37Z

1

In SQL you don't need = but just IN eg:

 con.query( 'SELECT Nomfamille,prenomutilisateur 
         FROM utilisateurs 
         WHERE idpublic  IN  (' + arr.join() + ')',  function (error, results, fields) {

edited Apr 13, 2018 at 16:59

answered Apr 13, 2018 at 16:56

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

Comments

Zeeshan Hassan Memon · Accepted Answer · 2018-04-13 16:58:29Z

1

Replace following:

IN =  ?

with:

IN (?)

answered Apr 13, 2018 at 16:58

Zeeshan Hassan Memon

8,3654 gold badges47 silver badges60 bronze badges

Collectives™ on Stack Overflow

right syntax for IN (sql nodejs)

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related