Select AND / OR problem

[eluser]xwero[/eluser]
It's not fully in the AR idea of creating database independent queries but you can add a string as a where part of the sql statement. In your case it would be something like

Code:

$query = $this->db->select('productID')->from('product')->where('(`productName` LIKE ‘clear %’ OR `productName` LIKE ‘% clear %’ OR `productName` LIKE ‘% clear’) AND (`productName` LIKE ‘file %’ OR `productName` LIKE ‘% file %’ OR `productName` LIKE ‘% file’)')->get();

I like to use the from method to be as close as possible to the actual sql statement but you can add the table as the first argument of the get method to save you some typing.