Can you point me to where I can get more info on this subject matter and how to do it within sequel?
On 20 March 2011 16:22, Jeremy Evans <[email protected]> wrote: > On Mar 19, 7:40 pm, dave <[email protected]> wrote: > > I am exploring the idea of using the built in MYSQL function Soundex > > any one got thoughts on the best way to achieve this? > > > > I want it so that regardless of the programming environment others may > > use the resulting text conversion is constantly entered and retrieved > > from the DB. > > > > upon collection I shall be extracting 10 - 20 chars of another field > > to help identify the right entry the user should select from the names > > returned (register type program). > > > > eg. > > > > user entered XXX YYYY > > > > xXX YYY 23 anyplace rd > > xxX yyy 55 hope rd > > > > hope you get the idea of what I'm wanting to do here... > > > > I am using Sequel or my connections so want to stay within this > > framework if at all possible, > > > > I'm thinking about having a stored procedure to obtain and return the > > soundex generated result thus i can save the generated value as a > > string. > > > > the field I am using is defined a char(4) as I've read that this is > > likely to give the best results but again am open to other folks views > > as long as it can be replicated in other programming languages (I know > > for sure PHP will be one not sure of others ergo wanting something > > that will be consistent for ALL languages) regardless of how they > > connect to the MYSQL db. > > If you want to have all connections to the database be able to use the > code, then a stored procedure or user defined function would work > best. > > Jeremy > > -- > You received this message because you are subscribed to the Google Groups > "sequel-talk" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sequel-talk?hl=en. > > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
