UNION query with codeigniter’s active record pattern

by

CodeIgniter’s ActiveRecord doesn’t support UNION, so you would just write your query and use the ActiveRecord’s query method.

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

More Related Contents:

  1. MySQL – How to unpivot columns to rows?
  2. SQL Performance UNION vs OR
  3. Combining UNION and LIMIT operations in MySQL query
  4. Using union and order by clause in mysql
  5. How would I use ON DUPLICATE KEY UPDATE in my CodeIgniter model?
  6. INSERT INTO SELECT statement with more columns which is not in another table
  7. How can I make SQL case sensitive string comparison on MySQL?
  8. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  9. 1052: Column ‘id’ in field list is ambiguous
  10. Count the occurrences of DISTINCT values
  11. Codeigniter – multiple database connections
  12. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  13. SQL: selecting rows where column value changed from previous row
  14. Cast int to varchar
  15. SQL query of multiple values in one cell
  16. Import SQL file into mysql
  17. MySQL SELECT last few days?
  18. How to skip certain database tables with mysqldump?
  19. “where 1=1” statement [duplicate]
  20. MySQL error 1241: Operand should contain 1 column(s)
  21. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  22. Is there a way to get the row number in Mysql like the rownum in oracle [duplicate]
  23. How to get a list of months between two dates in mysql
  24. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  25. Postgres LEFT JOIN with WHERE condition
  26. How to format number with “.” as thousands separator and “,” as decimal separator?
  27. Using DISTINCT and COUNT together in a MySQL Query
  28. How to check if field is null or empty in MySQL?
  29. Update multiple rows with multiple ‘where’ clauses for each individual row
  30. ORDER BY alphabet first then follow by number

Leave a Comment