We have a site currently active which searches through an SQL database of TV commercials. The main method of searching the system is via keyword. The search is currently developed in an ?or' fashion, and we need to have it modified so that it uses ?and' as a parameter, and 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 commercials 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
Thanks, and please leave any questions in PMB