Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed-east.nntpserver.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!headwall.stanford.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: s_komarovsky@yahoo.com (intermedia user) Newsgroups: comp.databases.oracle.misc Subject: Re: Oracle intermedia text select word only exclude others Date: 12 Dec 2002 05:11:36 -0800 Organization: http://groups.google.com/ Lines: 37 Message-ID: <6088037f.0212120511.44889dca@posting.google.com> References: <6088037f.0212101447.6295aa75@posting.google.com> <1_2cneeg06WN1mqgXTWcqA@comcast.com> NNTP-Posting-Host: 206.130.170.10 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1039698696 21256 127.0.0.1 (12 Dec 2002 13:11:36 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 12 Dec 2002 13:11:36 GMT Xref: newsfeed1.easynews.com comp.databases.oracle.misc:90469 X-Received-Date: Thu, 12 Dec 2002 06:11:12 MST (news.easynews.com) "Tim Arnold" wrote in message news:<1_2cneeg06WN1mqgXTWcqA@comcast.com>... > Use the minus '-' operator > > "intermedia user" wrote in message > news:6088037f.0212101447.6295aa75@posting.google.com... > > Hi, > > > > I want to select all records from the table that has some word and its > > synonims in the subjects field. > > > > select distinct subj_term from org_subj_terms > > where contains(subj_term,'syn(fish)')>0 > > > > The problem is I want to exclude records that also have other words. > > > > For example I want to select records with subject > > fish > > pets (synonym) > > > > but exclude > > records with fish equipment in the subject. > > > > How it can be done? > > > > thanks a lot. That's not I mean - I want to select all records that have only one particular word and no others. I don't know what others will be. In above example if I want to exclude equipment I would write - select * from foo where contains(subj,'fish ~equipment')>0 But what if i want to exclude all words that not fish? Pls. write the syntax in your answer. Thanks!