title: Prepared Statement in MySQL Connector
body: <p>I want to do a prepared statement like this:</p>
  
  <pre><code>pstmt=conn-&gt;prepareStatement("UPDATE partidos SET i?=? WHERE ID=?");
  pstmt-&gt;setInt(1,lazo);
  pstmt-&gt;setString(2,texto[lazo]);
  pstmt-&gt;setInt(3,var);
  pstmt-&gt;execute();
  </code></pre>
  
  <p>"lazo" is a variable in a for loop, texto[lazo] is a variable and var is another int variable.</p>
  
  <p>When I run this query, it throws an exception: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'i?=? WHERE ID=?' at line 1".</p>
  
  <p>It seems that it doesn't replace the '?'.</p>
  
  <p>I tried with stringstreams, but the problem didn't fix.</p>
  
  <p>Thanks.</p>