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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden