title: how can I delete all rows in a SQLite table which contains an element from an array
body: <p>I have a <em>SQLite</em> table (<em>masterTable</em>, below) in which one of the columns contains ledger numbers.</p>
  <p>What I'm trying to do in <em>node.js</em>, is to delete rows from the <em>masterTable</em> <strong>only if</strong> the column (<em>thisColumn</em>, see below) matchs the elements from a given array (<em>ledger_num</em>, see below).
  if the column contains any element from the array then the entire row must be deleted</p>
  <p>Namely, I have the following array(const ledger_num), with an unknown number of elements in it</p>
  <pre><code> const ledger_num = ['g12', 'g16', 'g45', 'gXX'];
  </code></pre>
  <pre><code>sqlite table = 
  thisColumn | name | date    | age | gender
  g1         | bob  | 15/1/21 | 15  | male
  g2         | john | 1/2/21  | 19  | male
  g3         | Emma | 9/12/21 | 20  | female
  .
  .
  g12        | rose | 1/1/21  | 21  | female
  .
  .
  g16        | ben  | 8/8/21  | 31  | male
  .
  .
  g45        | toby | 6/11/21 | 31  | male
  .
  gXX        | ---- | ---     | --  | ----
  </code></pre>
  <pre><code>db.run(`DELETE FROM masterTable WHERE thisColumn = ?`,ledger_num ,(err)=&gt;{
  if(err) console.log(err)
  })
  
  //so this is what i was doing but this clearly does nothing 
  </code></pre>
  <p>How do I do this in <em>node.js</em> so that the values from <em>thisColumn</em>, which match any of the elements in <em>ledger_num</em>, are deleted?</p>
  <pre><code>after deleting, the SQLite table should be  
  thisColumn | name | date    | age | gender
  g1         | bob  | 15/1/21 | 15  | male
  g2         | john | 1/2/21  | 19  | male
  g3         | Emma | 9/12/21 | 20  | female
  .
  .
  gXX        | ---- | ---     | --  | ----
  </code></pre>