Gossamer Forum
Home : General : Databases and SQL :

fulltext search query

Quote Reply
fulltext search query
Got a problem with mysql search.

I have the following;

SELECT *, MATCH(Can_CV)
AGAINST ('$searchresults' IN BOOLEAN MODE)
AS m FROM Candidates WHERE MATCH(Can_CV)
AGAINST ('$searchresults' IN BOOLEAN MODE) order by s DESC

However if i search for "keyword1 keyword2" it displays a score of 1 if one word is matched and 2 if both words are matched.

is it possible to have a count function e.g.
if "keyword1" is found 4 times and "keyword2" is found 3 times in the record it will have a score of "7"

any ideas?

thanks