Re: [PHP] Re: how to sort search results by relevance? thanks
Oh yeah! I just had old MySQL manual but I have upgraded MySQL and this function is working in my version, just was not described in docs Okay, thank you for help, I managed to do it. > 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 :) > > <>< <>< <>< <>< 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]
RE: [PHP] Re: how to sort search results by relevance?
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]
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]
Re: [PHP] Re: how to sort search results by relevance?
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 :) -- 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] Re: how to sort search results by relevance?
> 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? Youri <>< <>< <>< <>< 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] Re: how to sort search results by relevance?
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. -- CC -- 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]