Re: [GENERAL] SELECT speed with LIKE

[Frank Bax]

At 01:33 PM 4/01/00 -0500, you wrote:
>The table has a field called 'stname char(17)' which is indexed. The
>query is "SELECT * FROM data WHERE stname LIKE 'MAIN%'". I'm running on
>Redhat 6.1, 128MB ram, 40GB, P350. The actual index file is 4 MB.

I haven't tried it, but didn't someone mention a few weeks ago that  "WHERE
stname ~ '^MAIN'"  would produce the same results faster?