Re: [SQL] making 'like' queries quicker

On 1999-12-17, admin mentioned:

> Is there a way to make queries using the 'like' operator quicker, more
> specifically for queries that look like:
> select name from table where name like '%abc%';

These kinds of queries (where the search string starts with a wildcard)
never use indexes, so you're stuck with the sequential scan. A faster
computer is probably your best option. :(

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden