Welcome to WebmasterWorld Guest from 54.166.112.74

Forum Moderators: open

Message Too Old, No Replies

Match Against Question.

Tuning the relevance of the against keywords.

   
4:39 pm on Sep 22, 2005 (gmt 0)

10+ Year Member



Hello,

I've been working on a problem for a while now and can not seem to get the exact results I want from a Match/Against query.

Here is an example statement:

SELECT DISTINCT(url), MATCH(tags) AGAINST ('+(web2.0, web_), +(wiki), -rss_' IN BOOLEAN MODE) AS score FROM taggroups WHERE MATCH(tags) AGAINST ('+(web2.0, web_), +(wiki), -rss_' IN BOOLEAN MODE) ORDER BY score DESC

I'm basically looking for 3 things:
1) The results must contain at least one kw from the first set of (): +(web2.0, web_)
2) The results must contain at least one kw from the second set of (): +(wiki)
3) The results must NOT contain any of the remaining words: -rss_

Of course, the kws in the () could be more or fewer... I just need help with the basic syntax.

Thanks!