Re: Re: how to sort search results by relevance?
| From: | BRACK | Date: | Wed, 29 Aug 2001 16:40:17 +0000 |
| Subject: | Re: Re: how to sort search results by relevance? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-65051@lists.php.net to get a copy of this message | ||
On 29 Aug 2001, at 9:18, Mark Maggelet wrote:
> On Wed, 29 Aug 2001 13:58:34 +0200, BRACK (brak@nettaxi.com) wrote:
> >> In article <3B8A1D6A.4295.2947D@localhost>, bodybuilders@comic.com
> >> (Yura) wrote:
> >>
> >> > How to sort search results of php-mysql site by relevance?
> >>
> >> See the mysql manual's chapter on FULLTEXT indexes.
> >
> >I indexed column 'text' and tried to add "ORDER BY text DESC" in
> >query and deleted wildcards in front of variables but still it
> >doesn't
> >sort results by number of found words (or parts of words). Maybe I
> >didn't quite understand what to do?
>
> or maybe you didn't look up fulltext indexes :)
>
>
But I didn't find "FULLTEXT" word in entire MySQL library...?
<>< <>< <>< <>< God is our provider ><> ><>
><> ><>
http://www.body-builders.org