Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Indexing "free text": How?
This is Ok as long as the comment is some sort of VARCHAR. If "comment" is type
long --- Ya just canna use it in a where clause, Cap'n. I've had some success
a few years ago using embedded SQL to handle this problem, but, the rest is
left as an exercise.
Mark Zawadzki
>
> Hi Brian Rankin,
>
> Filter the records with the WHARE clause
>
> select * from tab where comments like '%abend%';
>
>
> I hope this will solve your problem.
>
> --Ch. Srinivas
> CMC Limited
> Hyderabad
> INDIA
> email: chsrini_at_tc4hq.cmc.stph.net
>
>
> >
> > I'm designing a small Oracle database that will incorporate a "comments"
> > field for each item in the database. Users will be able to enter any
> > desired text into this field relating to the item that's part of that
> > record.
> >
> > I need to make this "free text" field searchable - IOW, a user enters the
> > word "abend" into the app and the application searchs the comments field &
> > returns all records that contain the word "abend". What's the best way to
> > make this happen?
> >
> > I'm running Oracle 7.2.2.
> >
> > Sincerely,
> >
> > Brian Rankin
> > brankin_at_WestEd.org
> >
>
Received on Thu Jan 25 1996 - 14:55:37 CST
![]() |
![]() |