[eluser]Unknown[/eluser]
I use CI Active Database to select data from condition below
Code:
$this->select()->from('table')->where('fieldA != "dataA1"')->like('fieldB', $input)->or_like('fieldC',$input);
// Geberates QUERY
SELECT * FROM table WHERE fieldA != "dataA1" AND "fieldB" LIKE '%$input%' OR "fieldC" LIKE '%$input%';
but I want to Add (), becuase I don't want to show some data from first condition, but still show.
how I can do that