Re: OracleText: Search for exact string match

From: jaromir nemec <jaromir_at_db-nemec.com>
Date: Thu, 17 Jun 2004 23:38:15 +0200
Message-ID: <121e01c454b3$667eed50$3c02a8c0@JARAWIN>

Hi Susan,

if looking for *exact match*, what about:

select textid, text from text_table
where text = 'Lethal Weapon';

regards

Jaromir D.B. Nemec

• Original Message ----- From: "susan lam" <susanzlam_at_yahoo.com> To: <oracle-l_at_freelists.org> Sent: Thursday, June 17, 2004 2:11 PM Subject: RE: OracleText: Search for exact string match

> It returned the exact match I was looking for.

---

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 - 16:39:40 CDT