title: How can I use a variable as column name in mysql / express?
body: <p>Currently I have this issue, the problem is that the table name gets a set of quotation marks (ad it's a string) and this makes the server crash.</p>
  
  <pre><code>const update =  'the name of my column';
  const UpdateQuery = `UPDATE scores
      SET ${mysql.escape(update)} = ${mysql.escape(newValue)}
      WHERE score_id = ${mysql.escape(singleScore.score_id)}`;
  </code></pre>
  
  <p><code>mysql.escape()</code> works fine for everything except for the column name.</p>
  
  <p>This is what I get if I console.log the query after injecting the variables:</p>
  
  <pre><code>UPDATE scores
  SET 'the name of my column' = 1
  WHERE score_id = 1
  </code></pre>