Re: Searching in textfileds for patterns

Uwe Ziegenhagen wrote:
> Hello,
>
> I was asked to create a small PHP-interface to search in an Oracle 10.1
> database.
>
> A field will contain a small text, I need to search inside this text for
> a given keyword. I know the LIKE operator, but is it the best tool for
> this job or is there anything more sophisticated to search in fields?
>
> Thanks,
>
> Uwe

The CONTAINS operator available in Oracle Intermedia. This might be an Enterprise Edition option however. But as an Oracle instructor once said 'Who runs Standard?'

-- 
Sybrand Bakker
Senior Oracle DBA