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
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