title: Room: using variable in query
body: <p>I'm using Room DB in my app and I want, in a query, to put the column name as a variable so I can manipulate it "on the go" (while calling the method).</p>
  
  <p>example code ("name" suppose to be a variable represent a column):</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>@Query("UPDATE Products SET :name = :value WHERE prod_id = :prod_id")
      int updateName(String name,String value, String prod_id);</code></pre>
  </div>
  </div>
  </p>
  
  <p>I tried that but it does not compile, with an error that it needs to get a column and not a String.</p>
  
  <p>Is there any way that even a column will be placed as a variable?</p>