Re: Index - Soundex Question

2003-11-09 Thread Roger Baklund
* John Berman > Using mysql 3.28 There is no such version... you probably have version 3.23.something...? > I have a table with numerous columns and with a index on the surname > column > > In order to give user a choice of searching on an exact name or using > soundex I did the following: > > >

Index - Soundex Question

2003-11-09 Thread John Berman
Hi Using mysql 3.28 I have a table with numerous columns and with a index on the surname column In order to give user a choice of searching on an exact name or using soundex I did the following: Inserted a new field in the table, SURNAME_SDX char(5) Populated it from the surname column UPDA