How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?

by 
where('archived IS NOT NULL', null, false)

More Related Contents:

  1. Grouping WHERE clauses in Codeigniter
  2. Escaping SQL queries in Codeigniter
  3. how to select only one value sql
  4. How to create codeigniter dynamic menu from single table
  5. Comma separated numeric values – PHP CodeIgniter
  6. CodeIgniter – foreach loop
  7. PHP – Change value y,n in database [closed]
  8. How to insert multiple rows from array using CodeIgniter framework?
  9. strange character encoding of stored data , old script is showing them fine new one doesn’t
  10. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  11. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  12. PHP/MySQL Insert null values
  13. Find total number of results in mySQL query with offset+limit
  14. How to store NULL values in datetime fields in MySQL?
  15. How to create Codeigniter batch insert array
  16. How to add an ORDER BY clause using CodeIgniter’s Active Record methods?
  17. How can I Use Prepared Statements in CodeIgniter
  18. using nulls in a mysqli prepared statement
  19. What are the differences between backtick and single quote? Can I use IF statement in a query as above?
  20. PHP Check for NULL
  21. How to create Codeigniter language files from database?
  22. Trying to get property of non-object – CodeIgniter
  23. Codeigniter Transactions
  24. MySQL and PHP – insert NULL rather than empty string
  25. Inserting NOW() into Database with CodeIgniter’s Active Record
  26. MySQL, how to insert null dates
  27. How would I use ON DUPLICATE KEY UPDATE in my CodeIgniter model?
  28. Connecting to remote MySQL server using PHP
  29. Remotely connecting to a MySQL database
  30. How do i search from serialize field in mysql database?

Leave a Comment