title: Using a variable in a SQLITE Where clause in Node.js
body: <p>I am new to SQL and am having a hard time writing an SQL query for my node application. I would like to use a variable in the WHERE statement, but it seems like there is more to it. This is what I have tried...</p>
  
  <pre><code>var itemID = 3;
  
  var stmt = db.prepare("UPDATE tableName SET status = 'Out' WHERE id = itemID");
  stmt.run();
  stmt.finalize();
  </code></pre>
  
  <p>Any advice is appreciated. Thanks,
  Alex</p>