Query problem in Active Record Class

[eluser]Unknown[/eluser]
Hi,

How can I make separation in query parts???

I like to have this :

SELECT * FROM (`boxes`) WHERE `color` IN ('1')
AND ( `name` LIKE '%white%' OR `short` LIKE '%white%')


With Active Record Class I can't separate the likes from the where parameter, I could do this with Igniter:

SELECT * FROM (`boxes`) WHERE `color` IN ('1') AND `name` LIKE '%white%' OR `short` LIKE '%white%'

Is there any solution for this?

Thanks,
Chris