title: Using Mysql WHERE IN clause in codeigniter
body: <p>I have the following mysql query. Could you please tell me how to write the same query in Codeigniter's way ?</p>
  
  <pre><code>SELECT * FROM myTable 
           WHERE trans_id IN ( SELECT trans_id FROM myTable WHERE code='B') 
           AND code!='B'
  </code></pre>