Select AND / OR problem

[eluser]Cambo[/eluser]
Hi Resident Gurus

I am generating this query for a search using Active Record

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'

However, it is not formatting correctly. What I want is:

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')

Notice the brackets around the LIKE clauses?

How do I do that?

TIA
Cambo