title: Pass array in Mysql query with nodejs
body: <p>I have a simple query that I want to pass an array inside which has 5 items. I am using the <code>mysql</code> module so I know it can be done but am not doing the synatx right and therefore getting a syntax error. </p>
  
  <p>Below is the query:</p>
  
  <pre><code>`UPDATE table1 SET table1.col=0 WHERE (table1.col2) IN = (?) AND table1.id=(SELECT ...);`,[arr]
  
  //arr = [1,2,3,4,5];
  </code></pre>
  
  <p>I have tried: </p>
  
  <pre><code>`UPDATE table1 SET table1.col=0 WHERE (table1.col2) IN = (?,?,?,?,?) AND table1.id=(SELECT ...);`,[arr]`
  </code></pre>
  
  <p>but I still get a syntax error.</p>