Hi,
We are using fairly complex fulltext queries on multiple tables via
inner joins. We ge the correct results, but they are not sorted by
relevance as indicated in the manual. I tried to reconstruct the
query to use "AS score FROM tablename" and sort on the score, but
always get syntax errors when used in conjunction with inner joins.
It seems that the fulltext relevance decreasing behavior is only
true when querying against one table. Does anyone have any suggestions
on how to make this work properly? I'ved included a sample query
to illustrate my problem. Thanks!
Barry Wiegan
Senior Software Engineer
Internet Scout Project (htpp://scout.cs.wisc.edu/)
SELECT distinct annotation.RecordID FROM annotation INNER JOIN
authorintersection ON authorintersection.recordid=annotation.recordid
INNER JOIN pubintersection ON
pubintersection.recordid=annotation.recordid INNER JOIN
ControlledNameList ON
ControlledNameList.ControlledNameID=authorintersection.authorid OR
ControlledNameList.ControlledNameID=pubintersection.pubid WHERE (MATCH
(SiteTitle, SummaryBody, SiteURL) AGAINST ('Environmental Protection
Agency ') OR MATCH (ControlledName)
against ('Environmental Protection Agency ')) AND URLCorrect = 1 AND
Reviewed = 1 and SiteExtinct = 0
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
