List:General Discussion« Previous MessageNext Message »
From:misiaQ Date:November 4 2009 3:47pm
Subject:RE: Alphabetical search to and from
View as plain text  
> Or :
> alter table users add first_f_name char(1) not null;
> create index first_f_name_idx on users (first_f_name);
> update users set first_f_name = left(first_name,1);

... and don't forget the trigger on insert, update to keep that new column
always up to date.

Regards,
m.


----------------------------------------------------------------------
Konkurs: Wygrywaj nagrody z Pudzianem!
Sprawd
Thread
Alphabetical search to and fromDave M G4 Nov
  • Re: Alphabetical search to and fromJay Ess4 Nov
  • RE: Alphabetical search to and frommisiaQ4 Nov
    • Re: Alphabetical search to and fromMichael Dykman4 Nov
      • RE: Alphabetical search to and frommisiaQ4 Nov
        • Re: Alphabetical search to and fromMichael Dykman4 Nov
          • Re: Alphabetical search to and fromJay Ess4 Nov
            • RE: Alphabetical search to and frommisiaQ4 Nov
              • Re: Alphabetical search to and from [SOLVED]Dave M G5 Nov
  • Re: Alphabetical search to and fromSteve Edberg4 Nov