LIKE search and performance

["Andy" <frum(at)ar-sd(dot)net>]

Hi,

 

I have a table with varchar and text columns, and I have to search through these text in the whole table.

 

An example would be:

SELECT * FROM table

                             WHERE name like '%john%' or street like '%srt%'

 

Anyway, the query planner always does seq scan on the whole table and that takes some time. How can this be optimized or made in another way to be faster?

 

I tried to make indexes on the columns but no success.

 

PG 8.2

 

Regards,

Andy.