Re: keyword search help

thnx for reply sir. actually we are maintaining a cdrom database in
postgresql wherein we have cd rom titlename,author,year etc and keywords
as fields. we will store a set of keywords for each record. i want to know
how to enter those keywords in to database (whether to have comma between
keywords or plain) and code to search for keywords. i.e. if i enter a
keyword then it should search for that keyword in keyword field and
display result. keywords are strings an there will also be some
combinational search. i believe u will see to this and do the needful.
thanking you
with rgds
Arun

On Thu, 31 Jan 2002, Josh Berkus wrote:

> Arun,
>
> > i am arun from iisc,bangalore. we are on a database project and are
> > using
> > postgresql and php. i am finding some problems in keyword search. we
> > have
> > to store some keywords in a field and when we give some keywords it
> > should
> > search for the same in that field. how to store in database and how
> > to
> > access is the problem. pls help me in this matter.
> > with rgds
>
> Unfortunately, your question does not have a simple answer, as there
> are several options depending on waht you're searching, how often, how
> many users, and what kind of keywords you want to use.
>
> What you need is a book on the basics of database design. I do not know
> of one that has been translated into Indonesian. You may check out
> lists of English-language books at:
> http://techdocs.postgresql.org/bookreviews.php
> and
> http://www3.us.postgresql.org/books/index.html
>
> If English books are no use to you, or exchange rates put them out of
> your price range, e-mail me back and I will outline some simple
> methods for keyword searching.
>
> -Josh Berkus
>
> ______AGLIO DATABASE SOLUTIONS___________________________
> Josh Berkus
> Complete information technology josh(at)agliodbs(dot)com
> and data management solutions (415) 565-7293
> for law firms, small businesses fax 621-2533
> and non-profit organizations. San Francisco
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>