Re: indexing table by word not by column

On Tue, 20 Mar 2001 15:00:47 GMT,

        TurkBear <noone_at_nowhere.com> wrote:
> Another approach, if slower, would be to concatenate your search column:
>
> select * from table where column1||column2||column3||column4 like '%word%';
>
> Give it a try...

Don't bother. If the 'like' pattern starts with a percent sign ('%') or an underscore ('_'), no indexes will (or can) be used since it would require a full index scan anyway.

Remco

-- 
qn-195-66-31-144:  02:25:01 up 5 days,  1:49,  8 users,  load average: 1.03, 1.37, 1.70