OracleText: Search for exact string match

From: susan lam <susanzlam_at_yahoo.com>
Date: Wed, 16 Jun 2004 21:58:51 -0700 (PDT)
Message-ID: <20040617045851.41494.qmail@web90105.mail.scd.yahoo.com>

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

---

Received on Wed Jun 16 2004 - 23:55:41 CDT