id | name | status
1 | name | yes
2 | name | no
3 | name | yes
How i can count total status with value yes and with value no using active records ? Like count is : yes = 2 , no = 1
This is what i have tried so far
$this->db->select('count(status));
//$this->db->select('count(where status == 'yes')); // not working
$query = $this->db->get();