Hi THere,
I reallyhave two questions, so I'll ask the first one here as well -- are there any classes out there that are sarch algorithms, i.e. similar to what this forum uses when you use the search (which I did before I asked this question :-)??
If so a URL would be appreciated. Also, any articles on this class or other approaches so I can see others' thought processes on how to build efficient search algorithms.
SECOND QUESTION, and it's related to #1, does mysql short circuit in matching records?
define relevance needed as greater than x%
query:
SELECT whatever from some_table WHERE (first_and_best_condition_meets_minimum_relevance) OR (second_and_next_best_condition_meets_minimum_relevance) OR (third_second_and_first_condition_works) OR ...
could you do that query like this?
SELECT whatever from some_table WHERE
IF(condtion1 is good, 1,
IF(condition2 is good, 1,
IF(condition3 is good, 1, 0)))
Thank you for your interest in this,
Sam Fullman
Compass POint Media
