Weighted Fulltext on Column

[guitardave78]

Is it possible to do a fulltext search but to weight the relevance of each column
If i could do it in my wording it would look like this

match(index_title*10,index_desc,index_keywords*5)

}...the bane of my life!

http://www.fuzzyd.co.uk

 

[TonyGroves]

You could use something like:
[tt]
10*(MATCH(index_title)AGAINST('searchterm'))
+(MATCH(index_desc)AGAINST('searchterm')
+5*(MATCH(index_keywords)AGAINST('searchterm))
[/tt]
which would produce a weighted rating.

 

[guitardave78]

cool will give that a try

}...the bane of my life!

http://www.fuzzyd.co.uk