RE: OracleText: Search for exact string match
- From: "Grant Allen" <Grant.Allen@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 17 Jun 2004 15:16:18 +1000
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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of susan lam
> Sent: Thursday, 17 June 2004 14:59
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
