Re: FULLTEXT search sorting results
| From: | Mark Maggelet | Date: | Sat, 01 Sep 2001 18:50:47 +0000 |
| Subject: | Re: FULLTEXT search sorting results | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-65617@lists.php.net to get a copy of this message | ||
On Sat, 1 Sep 2001 14:01:57 +0200, BRACK (brak@nettaxi.com) wrote:
>I have query -
>
>$res = mysql_query("SELECT
>skits.*,category.cat_id,category.cat_name FROM skits,category WHERE
>MATCH (title,descr,skits) AGAINST ('%$search_idea%') and skits.lang
>like 'English' and skits.category like category.cat_id limit
>$limit,10 ");
>
>I expect to get results sorted by relevance and it actually does BUT
>(!)
>inside of categories =( I mean it sorts result first by category and
>second by relevance. How do I make it to be sorted by only
relevance?
try it like this:
$res = mysql_query("SELECT
skits.*,category.cat_id,category.cat_name,MATCH (title,descr,skits)
AGAINST ('%$search_idea%') as relevance FROM skits,category WHERE
skits.lang like 'English' and skits.category like category.cat_id
having relevance>0 order by relevance desc limit $limit,10 ");