Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: find email address in clob

Re: find email address in clob

From: Ganesh Raja <ganesh.raja_at_nospam.logicacmg.com>
Date: Fri, 5 Mar 2004 17:28:06 +0800
Message-ID: <newscache$wmj3uh$y0d$1@animal.logica.co.uk>


A Wild guess here .. No way for me to test it..

select * from mytable
where contains(a_text,'\@msn.com') > 0 Escape '\'

-- 
Cheers,
Ganesh Raja


"Cookie Monster" <cookie.monster_at_somewhere.com> wrote in message
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.
>
> Thanks,
> Cookie.
>
>
Received on Fri Mar 05 2004 - 03:28:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US