Welcome to WebmasterWorld Guest from 54.196.175.173

Forum Moderators: open

Message Too Old, No Replies

Match Against Question.

Tuning the relevance of the against keywords.

     

dascgo

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



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!

 

Featured Threads

Hot Threads This Week

Hot Threads This Month