```
  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();

```