Active Records and complex queries

[eluser]Aken[/eluser]
If you want to do two where groups, you can do something like this:

Code:

$this->db->where('(column = value AND column = value)');
$this->db->or_where('(column = value AND column = value)');

You might need to specify the third parameter of where() and or_where() as FALSE to prevent backtick escaping, if you run into issues with that.

That's the best you're going to get with the current version. Although there's nothing wrong with writing the query out yourself and using $this->db->query() if you want (so long as you don't need to support multiple DB types).