Re: ranking database searches
| From: | CC Zona | Date: | Wed, 08 Aug 2001 21:16:32 +0000 |
| Subject: | Re: ranking database searches | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11143@lists.php.net to get a copy of this message | ||
In article <NDBBJLBCALPJGKIICNNMGEAOEBAA.mike@prairiefirewebdesign.com>,
mike@prairiefirewebdesign.com (Michael Hall) wrote:
> This may be more trouble than I'm interested in, but I'm working on search
> functionality for a number of our MySQL database projects.
>
> I'm looking for ways (or just ideas about ways) to set up a ranking system
> such that I could have exact matches at the top of the list, then multiple
> partial matches listed below that, and single partial matches below that,
> etc.
See the MySQL manual's section on FULLTEXT indexes. It won't necessarily
return results in exactly the order you describe, but will go you one
better by ordering based on relevancy.
--
CC