active record query help

[eluser]Armchair Samurai[/eluser]
I'm not sure why you're dead set on using AR when it doesn't support the feature you're looking for, but if you must do it the hard way:

Code:

$name = $this->db->escape("%$arr[name]%");

$this->db->select('c.id,customer.pid, c.name, c.created_by, c.name AS customer_name, c.notes, cp.name AS parent_customer');
$this->db->where('(cp.name LIKE $name OR c.name LIKE $name OR c.notes LIKE $name)', NULL, FALSE);
$this->db->where('c.is_parent', 0);
$this->db->where('c.active', 1);