Searching in textfileds for patterns
This is a discussion on Searching in textfileds for patterns within the Oracle Miscellaneous forums, part of the Oracle Database category; --> Hello, I was asked to create a small PHP-interface to search in an Oracle 10.1 database. A field will ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 11:57 AM
| ||||
| ||||
 Searching in textfileds for patterns 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      |
|
04-08-2008, 11:57 AM
| |||
| |||
| 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 |
|
04-08-2008, 11:57 AM
| ||||
| ||||
| 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 IIRC Oracle 10 can do regexp ... so you might make your php code a little bit more cryptic by adding fancy patterns  |
Linear Mode
