title: CodeIgniter parameterize integer and string
body: <pre><code>$code = Array(1,2,3,4)
  $sql = "SELECT * FROM Table1 WHERE Field1 IN (?)";
  $query = $this-&gt;db-&gt;query($sql, array($code));
  </code></pre>
  
  <p><code>$this-&gt;db-&gt;last_query()</code> will show</p>
  
  <pre><code>"SELECT * FROM Table1 WHERE Field1 IN ('1,2,3,4')"
  </code></pre>
  
  <p>How can I remove the single quote in the IN condition?</p>
  
  <p>Even if the <code>$code</code> is array of strings, example</p>
  
  <pre><code>$code = Array('This one', 'Next code', 'And this')
  </code></pre>
  
  <p>the statement will be:</p>
  
  <pre><code>"SELECT * FROM Table1 WHERE Field1 IN ('This one, Next Code, And This')"
  </code></pre>
  
  <p>Am I missing something ?</p>
  
  <p>TIA.</p>