Hi all,

I have quite a complex series of n:n relationships in my database which I want to be able to use as criteria. I'm fairly sure I can work this out with CakePHP but I also want to be able to perform a text search on the "description" type field (probably using something like Sphinx).

What's the best way to do this?