Re: find email address in clob

From: Bib Endum <gd-newsgroups_at_spamex.com>
Date: Fri, 5 Mar 2004 09:06:54 -0500
Message-ID: <bQ%1c.9073$jw2.615698@news20.bellglobal.com>

"Cookie Monster" <cookie.monster_at_somewhere.com> a écrit dans le message de news:c29fj6$1pqikj$1_at_ID-82797.news.uni-berlin.de...
> Hi,
>
> I am using Oracle 9i Text and I have the below query statement which
returns
> the wrong results:
>
> select * from mytable
> where contains(a_text,'@msn.com') > 0
>
> The problem is this returns ALL documents with msn.com and not the
documents
> containing only '@msn.com' basically the @ is ignored. I just want to find
> the email addresses. Does anyone know how I can force a search for this
> query and get oracle text to use the @ ?? I tried escaping the character
and
> everything but this no affect on the results.
>

The problem is that maybe the @ character is in the stoplist, as are most punctuation character and is not indexed per se. Received on Fri Mar 05 2004 - 08:06:54 CST