In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (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
--
PHP Database 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]