Hello, I’ve made a fulltext search in my site, but I have a problem. I want to order the results by relevant but I can’t put the match query into the select.
I’m trying to do sth like that:
$criteria->select = "MATCH (title, content, tags) AGAINST ('*{$_GET['q']}*' IN BOOLEAN MODE) as relevance";
But the Yii framework tells me that there’s no column MATCH (title".
Is there any way to use the fulltext search or can I "lie" the Yii and use it in the select?
I would guess that you have to specify MATCH … AGAINST … in the WHERE clause, not in SELECT part. But I’m not at all familiar with MATCH AGAINST. Maybe you can give it a try.