CodeIgniter: How to use WHERE clause and OR clause

Question

I am using the following code to select from a MySQL database with a Code Igniter webapp:

$query = $this->db->get_where('mytable',array('id'=>10)); 

This works great! But I want to write the following MySQL statement using the CI library?

SELECT * FROM `mytable` WHERE `id`='10' OR `field`='value' 

Any ideas? Thanks!

Answer 1

$where = "name='Joe' AND status='boss' OR status='active'";  $this->db->where($where); 

Answer 2

You can use or_where() for that - example from the CI docs:

$this->db->where('name !=', $name);  $this->db->or_where('id >', $id);   // Produces: WHERE name != 'Joe' OR id > 50