How Can I Perform a UNION Query Using CodeIgniter's Active Record?

CodeIgniter Active Record UNION Query

CodeIgniter's Active Record pattern simplifies database interactions by providing a convenient interface. However, one limitation is that it doesn't natively support UNION queries.

To perform a UNION query using CodeIgniter's Active Record, you need to directly execute the SQL query yourself:

$this->db->query('SELECT column_name(s) FROM table_name1 UNION SELECT column_name(s) FROM table_name2');

This query combines the results of two subqueries into a single dataset, effectively appending the rows from both tables into one combined result set.

Note that this approach requires you to manually write the UNION query, without relying on CodeIgniter's Active Record query builder methods. However, it provides flexibility when dealing with complex queries that may not be fully supported by the Active Record pattern.

The above is the detailed content of How Can I Perform a UNION Query Using CodeIgniter's Active Record?. For more information, please follow other related articles on the PHP Chinese website!