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.


PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to