Active Record: COUNT WHERE?

[eluser]BravoAlpha[/eluser]
Does the Active Record class have a way to COUNT that supports a WHERE clause?

The current MySQL driver uses this:

Code:

function count_all($table = '')
    {
        if ($table == '')
            return '0';
    
        $query = $this->query("SELECT COUNT(*) AS numrows FROM `".$this->dbprefix.$table."`");
        
        if ($query->num_rows() == 0)
            return '0';

        $row = $query->row();
        return $row->numrows;
    }