Re: PL/SQL and building a search engine

In article <621ngd$nf9$1_at_news00.btx.dtag.de>, GreMa_at_t-online.de (Matthias Gresz) writes:

>Bryan J. Gentile wrote:
>>
>> I am trying to build a small search engine via PL/SQL stored procedure.
>> I guess my question is what is the best way to compare a string coming
>> into the procedure with what exists in the database. For example: I am
>> building a message posting web board. I want a user to be able to
>> search for messages which may exist in a given topic. Therefore I would
>> have them type in a keyword and then pass that keyword into the stored
>> procedure. In the database I have a message_subject field and a message
>> field. Now how could I compare the keyword that was passed into the
>> search engine with the messages that exist in the database for that
>> topic?
>>
>> If answering this question, could you send response via email since I
>> cannot check the newsgroup too many times during the day. Thanks.
>>
>> --
>> **************************************
>> Bryan J. Gentile
>> Consultant
>> Business Data Services, Inc.
>> Glastonbury, CT 06033
>> Phone: (860) 633-3693 (ext. 3025)
>> Vmail: (ext. 6030)
>> **************************************
>Hi,
>
>take a look at the 'soundex'-function.
>--
>Regards
>
>M.Gresz :-)
>
>

How about using LIKE as in

   where <message_field> like '%' || <search_field> || '%' ?

This could, of course, be quite expensive. Received on Thu Oct 30 1997 - 00:00:00 CST