Re: Oracle intermedia text select word only exclude others

"Tim Arnold" <timkarnold_at_comcast.net> wrote in message news:<1_2cneeg06WN1mqgXTWcqA_at_comcast.com>...
> Use the minus '-' operator
>
> "intermedia user" <s_komarovsky_at_yahoo.com> wrote in message
> news:6088037f.0212101447.6295aa75_at_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! Received on Thu Dec 12 2002 - 07:11:36 CST