Re: Intermedia search for "<"

Dave wrote:
> I'm trying to resolve an issue where CLOBS and LONGS contain a
> less-than sign. I need to find another occurrence of this to ensure
> that I'm correct, but can't find one. Does anyone know the correct
> sql for a fulltext search on "<"?
> I've tried all of the usual suspects:
>
> select * from abstracts_t where contains(abstract_text,'<') > 0;
> select * from abstracts_t where contains(abstract_text,'\<') > 0;
> etc etc
> None of which return any records (I know that at least one occurrence
> of abstract_text contains a <).
>
> It's as though it doesn't recognize the '<'. Any help would be
> tremendous. Thanks in advance.
>
> Dave F.

Is '<' in your stoplist? Won't be indexed, then

-- 
Regards, Frank van Bortel