I need help on the best way to handle a field that could have many different ways of naming something.
For instance, school name Let's take Saint Joseph's University This could be Saint Joseph's Univeristy, U. of St. Joe, SJU, Univ. St. Joe, etc... In this case, I don't think I can always get what I want by doing a select from table where name like "something". Is there a practical/better way to handle this kind of thing. This will come up a lot. I'm thinking right now I will have to maintain my own mapping file for each school... Something like Kansas, KU, Kansas University, University of Kansas, etc... Any ideas? Thanks, Taylor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
