SELECT IN SELECT query in CodeIgniter

Question

I have a query similar to this   SELECT username  FROM users  WHERE locationid IN     SELECT locationid FROM locations WHERE countryid          is a value I get from end user   How could I run this query in CodeIgniter  I can t find a solution in CodeIgnite s user guide   Thank you so much for your answers   Regards

User · Answer

Look here   Basically you have to do bind params    sql    SELECT username FROM users WHERE locationid IN  SELECT locationid FROM locations WHERE countryid         this- gt db- gt query  sql     COUNTRY NAME        But  like Mr E said  use joins    sql    select username from users inner join locations on users locationid   locations locationid where countryid          this- gt db- gt query  sql     COUNTRY NAME

User · Answer

I think you can create a simple SQL query    sql  select username from user where id in  select id from idtables     query  this- gt db- gt query  sql     and then you can use it normally

User · Answer

Also  to note - the Active Record Class also has a  this- gt db- gt where in   method

User · Answer

Note that these solutions use the Code Igniter Active Records Class  This method uses sub queries like you wish but you should sanitize  countryId yourself    this- gt db- gt select  username            - gt from  user            - gt where   locationId  in     select  locationId  from  locations  where  countryId       countryId      false           - gt get      Or this method would do it using joins and will sanitize the data for you  recommended     this- gt db- gt select  username            - gt from  users            - gt join  locations    users locationid   locations locationid    inner            - gt where  countryid    countryId           - gt get

[codeigniter] "SELECT ... IN (SELECT ...)" query in CodeIgniter

Examples related to codeigniter