I am literally brand new to all of this "search engine" stuff, and I am learning as I go.
I read tutorials on building search engines, and understand the importance of building and adding fulltext indices in MySQL, which I've done, on the proper fields in tables.
I have my query built as well that will do the search based upon criteria the user enters:
SELECT image.id, count(image.image_name) as score FROM image WHERE image_atl REGEXP '[S|s]tuff$' GROUP BY image.id
In this example, I am only searching under one criteria, thus I would assume relevancy would be dependant on it matching this under 1 criteria, however, what about this case:
SELECT image.id, count(image.image_name) as score FROM image WHERE image_atl REGEXP '[S|s]tuff$' OR image_alt REGEXP '[F|f]oo$' GROUP BY image.id
If I have criteria joined by an OR expression, do I match my criteria to 1 field instance or 2 or what?
Basically what I need is an idea of the methodology of calculating SQL relevancy.
Thanx
Phil
