Re: ranking database searches
| From: | grant | Date: | Wed, 08 Aug 2001 20:32:10 +0000 |
| Subject: | Re: ranking database searches | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11142@lists.php.net to get a copy of this message | ||
2 ideas:
1) Define the loosest item that returns results (likely regex) then search
with slightly tighter criteria within the results.
Good for situations where even partial matches are a small percentage of
the total data
2) Check every record, and give it a score based on proximity to the
search criteria, then sort.
Good for returning the top N results with the possible results being a
large portion of the total.
Of course you could combine the two and get a subset, then score it and
sort....
Just ideas
______________________________________________________________________________
Your mouse has moved.
You must restart Windows for your changes to take effect.
#!/usr/bin/perl
print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);