We are currently rebuilding a site currently active which searches through an SQL database of video and audio clips. The main method of searching the system is via keyword. We need to have it modified so that the results are displayed based on relevancy, similar to Google.
To clarify, currently in the system if a user searches using the entry 'holiday toys' the system provides results of ALL assets containing either one of the search words (holiday OR toys in this case). Instead, what SHOULD happen is first in the results should be any commercial containing BOTH words, then afterwards, spots should be listed containing just one or the other.
Essentially we want to use the Google approach, where the results are listed based on relevancy to the search.
Quick example: 3 keywords searched:
Results listing in order:
[url removed, login to view] containing all 3 keywords
[url removed, login to view] containing any 2 of the 3 keywords
[url removed, login to view] containing any 1 of the 3 keywords
Each asset has multiple attribues in the DB (director, agency, category, etc. The system is correctly searching all of these fields. The search needs to utilize all field when doing the relevancy ranking.
Looking for a developer who can do this right away, and has experience in RELAVANCY based searching.
Note: This system is Windows 2008 server, PHP with MSSQL 2008, NOT mySQL.
Thanks, and please leave any questions in PMB