June 6th, 2003, 11:04 PM
|
|
Junior Member
|
|
Join Date: Jun 2003
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
MySQL FULLTEXT Search: Relavances in BOOLEAN mode
Well, I havent seen this issue being addressed much, but when performing a fulltext search 'in BOOLEAN MODE', the relevances returned are almost always 1. This poses a problem for my application, and the following workaround method still doesn't work for some searches. Sometimes I dont receive results from a search that should return results.
"SELECT MATCH('Content') AGAINST ('keyword1 keyword2') as Relevance FROM table WHERE MATCH ('Content') AGAINST('+keyword1 +keyword2' IN BOOLEAN MODE) HAVING Relevance > 0.2 ORDER BY Relevance DESC"
Any thoughts?
Last edited by jtey : June 6th, 2003 at 11:38 PM.
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
