RE: [PHP] Re: how to sort search results by relevance?

[Michael Geier, CDM Systems Admin]

www.google.com
search "relevance searches in MySQL"

1. www.mysql.com/documentation/mysql/bychapter/manual_Fulltext_Search.html

-----Original Message-----
From: BRACK [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 11:40 AM
To: Mark Maggelet
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Re: how to sort search results by relevance?


On 29 Aug 2001, at 9:18, Mark Maggelet wrote:

> On Wed, 29 Aug 2001 13:58:34 +0200, BRACK ([EMAIL PROTECTED]) wrote:
> >> In article <3B8A1D6A.4295.2947D@localhost>, [EMAIL PROTECTED]
> >> (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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]