Re: Search Problem

You might be able to simplify your SQL a bit by doing something like this for searching for a phone number:

SELECT * FROM mytable
WHERE INSTR(field1||field2||...||field20,'555-1212') > 0

It wouldn't buy you anything in terms of performance, though.

"Matt Morton-Allen" <matt_at_phoroneus.com> wrote in message news:rjFL7.3$aE.1116_at_news0.optus.net.au...
> Hi,
> I am trying to create a web based search of a simple table of a
telephone
> directory. The search is a standard web search where you enter the
search
> term and get the results that match. My problem is that cannot
figure out
> how to search many small fields (20) for the one term without a
massively
> inefficient use of OR's and LIKEs '%text%'.
>
> I looked at the interMedia stuff which seems okay but seems to
require an
> index for each field. Since some of the fields are quite small (as
little as
> 20 characters) this seems like overkill and doesn't really solve the
OR
> problem anyway.
>
> So any suggestions on where to look?
>
> Matt.
>
>
Received on Sat Nov 24 2001 - 07:09:58 CST