Using a variable in a SQLITE Where clause in Node.js
<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>