Using Mysql WHERE IN clause in codeigniter

Question

I have the following mysql query  Could you please tell me how to write the same query in Codeigniter s way    SELECT   FROM myTable           WHERE trans id IN   SELECT trans id FROM myTable WHERE code  B             AND code   B

User · Answer

try this   return  this- gt db- gt query        SELECT   FROM myTable       WHERE trans id IN   SELECT trans id FROM myTable WHERE code  B         AND code   B         - gt result array      Is not active record but is codeigniter s way http   codeigniter com user guide database examples html see Standard Query With Multiple Results  Array Version  section

User · Answer

You can use sub query way of codeigniter to do this for this purpose you will have to hack codeigniter  like this Go to system database DB active rec php Remove public or protected keyword from these functions  public function  compile select  select override   FALSE  public function  reset select     Now subquery writing in available And now here is your query with active record   this- gt db- gt select  trans id     this- gt db- gt from  myTable     this- gt db- gt where  code   B     subQuery    this- gt db- gt  compile select      this- gt db- gt  reset select       And now your main query  this- gt db- gt select        this- gt db- gt where in   subQuery     this- gt db- gt where  code       B     this- gt db- gt get  myTable      And the thing is done  Cheers    Note   While using sub queries you must use    this- gt db- gt from  myTable     instead of    this- gt db- gt get  myTable     which runs the query  Watch this too  How can I rewrite this SQL into CodeIgniter  39 s Active Records   Note   In Codeigntier 3 these functions are already public so you do not need to hack them

User · Answer

Try this one    this- gt db- gt select        this- gt db- gt where in   SELECT trans id FROM myTable WHERE code    B       this- gt db- gt where  code       B     this- gt db- gt get  myTable      Note   this- db- select       is optional when you are selecting all columns from table

User · Answer

data    this- gt db- gt get where  columnname  array  code    gt   B      this- gt db- gt where in  columnname   data    this- gt db- gt where  code      B     query     this- gt db- gt get    return  query- gt result array

[codeigniter] Using Mysql WHERE IN clause in codeigniter

Examples related to codeigniter

Examples related to codeigniter-2