Hi, For this only RDBMS came into being. You keep your master data in a table with relevent descriptions, codify the item. Use the code in other location. In qa web page always search against/show the full desc of what others require. Add a category like school/university/pre-matric etc. this could simplify the visitor to make logical and correct naming methods. In a nutshell when accepting info from users, show them the full desc/ask them write the full desc, add a category. I hope this could solve ur problem.
On Tue, 19 Oct 2004 12:38:49 -0500, Lewick, Taylor <[EMAIL PROTECTED]> wrote: > 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] > > -- Thanks & Regards, Eldo Skaria -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
