Grant,
Thanks for your response.
I've a typo error in my original question.
I got the following result which was what I'm looking
for:
select textid, text from text_table
where contains(text,'{Lethal Weapon 2}')>0;
TEXTID TEXT
-------- ---------------------
2 Lethal Weapon 2
It returned the exact match I was looking for.
However, if I changed the query to:
select textid, text from text_table
where contains(text,'{Lethal Weapon}')>0;
TEXTID TEXT
-------- ---------------------
1 Lethal Weapon
2 Lethal Weapon 2
3 Lethal Weapon 4
It returned all the possible matches that contain
"Lethal Weapon". I would like Oracle Text to return
just "Lethal Weapon".
I tried changing '>0' to '=100' but it returned no
record.
select textid, text, score(100) from text_table
where contains(text,'{Lethal Weapon}',100)=100;
no rows selected
To my understanding, '>0' or '=100', etc is the score.
I do not know why the scores for each record returned
below are the same ie '5'. I would think that the
exact string match "Lethal Weapon" would get a higher
score than "Lethal Weapon 2" or "Lethal Weapon 4"??
select textid, text, score(100) from text_table
where contains(text,'{Lethal Weapon}',100)>0;
TEXTID TEXT score(100)
-------- --------------------- ----------
1 Lethal Weapon 5
2 Lethal Weapon 2 5
3 Lethal Weapon 4 5
Any one? Thanks for any assistance you can provide..
susan
- Grant Allen <Grant.Allen_at_towersoft.com.au> wrote:
> Susan,
>
> I'm a bit rusty on the precision syntax, but I think
> you'd need
>
> select textid, text from text_table where
> contains(text,'{Lethal Weapon 2}') = 100
>
> i.e. 100% match from contains() ... not the "more
> than 0% match" that you had.
>
> I'm happy to be corrected by those in the know.
>
> Ciao
> Fuzzy
> :-)
>
> ----------------------------------
> "Everything you think, do, and say
> was in the pill you took today."
> -- Zager and Evans
>
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> > [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
> susan lam
> > Sent: Thursday, 17 June 2004 14:59
> > To: oracle-l_at_freelists.org
> > Subject: OracleText: Search for exact string match
> >
> >
> > Hi,
> > I'm trying to write a query in Oracle Text that
> > returns an exact string match but the output also
> > returns records that are partially matched.
> >
> > For example, I want the query below to just return
> ONE
> > record - "Lethal Weapon 2" but it also returned a
> > partially matched record - "Lethal Weapon 4".
> >
> > select textid, text from text_table
> > where contains(text,'{Lethal Weapon 2}')>0;
> > TEXTID TEXT
> > -------- ---------------------
> > 2 Lethal Weapon 2
> > 3 Lethal Weapon 4
> >
> > 2 rows selected.
> >
> > Any idea how I can rewrite my query?
> >
> > Thanks in advance.
> >
> > susan
> >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > New and Improved Yahoo! Mail - 100MB free storage!
> > http://promotions.yahoo.com/new_mail
> >
>
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >
>
> > To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> http://www.freelists.org/archives/oracle-l/
> > FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
> >
>
> >
>
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
> To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> http://www.freelists.org/archives/oracle-l/
> FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
>
>
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Jun 17 2004 - 07:08:42 CDT
