RE: OracleText: Search for exact string match

From: Grant Allen <Grant.Allen_at_towersoft.com.au>
Date: Thu, 17 Jun 2004 15:16:18 +1000
Message-ID: <DCFC52557FAC7640A8782B13032B81B0373A57@bishopsfinger.towersoft.canberra>

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
-----------------------------------------------------------------

Received on Thu Jun 17 2004 - 00:15:33 CDT