[eluser]SeameX[/eluser]
Hello Guys,
i want to have something like this:
Code:
SELECT * FROM x WHERE cid = 'x' AND (col = '%word%' OR col = '%word%')
how can i do the brakets?
So far i have this
Code:
$this->db->select('cid, name, node_cid, sort, active')->where('cid',$cid)
The user should be able to search for key words. There is a foreach doing this all the time:
Code:
$this->db->or_like($col, $word);
So i have everything but without brakets and thats not working. Is there a easy way to do it?
Best regards
SeameX