MATCH - AGAINST in CakePHP

Question

I am new in CakePHP and now I can't transform the query:

SELECT *, 
MATCH (title, post, tags) AGAINST ('dialux' IN BOOLEAN MODE) as REL
FROM posts 
WHERE MATCH (title, post, tags) AGAINST ('dialux' IN BOOLEAN MODE)
ORDER BY REL DESC;

in something like this:

$this->Post->find('all', xxx);

Any ideas? Thanks.

Answer 1

Not sure if this is helpful as it is from the page that has already been suggested by mark

But you could try something like this:

$query = 'SELECT *, 
MATCH (title, post, tags) AGAINST ('dialux' IN BOOLEAN MODE) as REL
FROM posts 
WHERE MATCH (title, post, tags) AGAINST ('dialux' IN BOOLEAN MODE)
ORDER BY REL DESC;';

$this->Post->query($query);