Re: Keyword Search Implementation

Well, I've found the answer myself!

There is an Oracle add-on called InterMedia that provides tools for all kinds of searches. So we've started to use this. InterMedia is quite a large and complicated system with several capabilities.

Salaam Yitbarek

In article <8emokf$2p4$1_at_nnrp1.deja.com>,   yitbsal_at_statcan.ca wrote:
> Hi,
>
> We are trying to implement keyword search of some tables in our
> database.
>
> Unfortunately, the required SQL statement is getting quite involved.
 For
> example, if we are looking for the keyword 'blue', the following sql
> statement:
>
> select id1 into var_id1
> from my_table
> where my_search_field like '%blue%';
>
> will return rows that contain the substring 'blue' instead of the word
> 'blue'. For the word 'blue', the where clause would have to be
 something
> like:
>
> where my_search_field like '% blue %'
> or my_search_field like '% blue.%'
> or my_search_field like '%.blue %'
> or my_search_field like '% blue'
> or my_search_field like 'blue.%'
> etc.
>
> It gets involved. Of course, another approach is to normalize
> my_search_field in another column just for searching purposes. But I'd
> like to know what others out there are doing in this regard.
>
> Thanks,
> Salaam Yitbarek
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu May 04 2000 - 00:00:00 CDT