title: How to convert tuple query from "or" to "and" operation in php codeigniter
body: <pre><code>SELECT 
   `reference_of_common` 
  FROM `tbl_taxonomic_character` 
  WHERE
  (root_character,character_sub1) IN (
                                    ('habit','Climber'),
                                    ('floral type','pentamerous')
                                   )
  group by reference_of_common; 
  </code></pre>
  
  <p>This query work as an OR operation. How can I write the query for AND operation? </p>
  
  <p>Please help me</p>