mysql - Codeigniter Active Record 'where_or' grouping

Question

Is it possible to group and_where / or_where / or_like... statements together so as not to mix with other and/where statements.

Something that would result in

WHERE city = 'My City' AND state = 'My State' AND (name LIKE %name1% OR name LIKE %name2%)

Answer 1

I know this is a little late, but I found this post when looking into it and found a better solution than the one proposed by Sean.

$name = 'Bob';

$this->db->where('city', 'My City');
$this->db->where('state', 'My State');
$this->db->group_start();
    $this->db->like('name', $name);
    $this->db->or_like('name', $name);
$this->db->group_end();