homepage Welcome to WebmasterWorld Guest from 54.226.147.84
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Match Against Question.
Tuning the relevance of the against keywords.
dascgo

10+ Year Member



 
Msg#: 50 posted 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!

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved