Re: find email address in clob

From: Mark Bole <makbo_at_pacbell.net>
Date: Sat, 06 Mar 2004 01:12:25 GMT
Message-ID: <Zz92c.20476$tH4.10892@newssvr29.news.prodigy.com>

Cookie Monster wrote:
> 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.
>

try

chr(64) || 'msn.com'

as an alternative. Received on Fri Mar 05 2004 - 19:12:25 CST