find email address in clob

From: Cookie Monster <cookie.monster_at_somewhere.com>
Date: Fri, 5 Mar 2004 10:00:48 +0100
Message-ID: <c29fj6$1pqikj$1@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:00:48 CST