> 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¼ >> http://link.interia.pl/f240e -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org