TK wrote:
At 05:02 PM 6/12/2004 +0200, Harald Fuchs wrote:
Other DBMSs like PostgreSQL grok indexes on functional expressions;
MySQL doesn't. Thus your only choice seems to be storing the
uppercased initial in a separate column and putting an index on that
column.
As I indicated, I already tried
At 05:02 PM 6/12/2004 +0200, Harald Fuchs wrote:
>Other DBMSs like PostgreSQL grok indexes on functional expressions;
>MySQL doesn't. Thus your only choice seems to be storing the
>uppercased initial in a separate column and putting an index on that
>column.
As I indicated, I already tried that i
In article <[EMAIL PROTECTED]>,
TK <[EMAIL PROTECTED]> writes:
> I'm still trying to come up with an efficient way to query my table of names for all
> first initials. Seems to have stumped everyone.
> I.e. There are 50,000 names, and I want the final result to be:
> A, B, C, F, H, I, J, K..
I'm still trying to come up with an efficient way to query my table of names for all
first initials. Seems to have stumped everyone.
I.e. There are 50,000 names, and I want the final result to be:
A, B, C, F, H, I, J, K...
That is, a list of all first initials that are actually present i