Complex statements using active record

[eluser]blasto333[/eluser]
Is it possible to do:

SELECT * FROM table WHERE (a=b or a=c) and d=e

[eluser]Dennis Rasmussen[/eluser]
I don't think so, however you can write your own clauses manually:

Code:

$where = "(a=b or a=c) and d=e";
$this->db->where($where);