One thing that has always puzzled me is how poeple are
gaurding against duplication in columns where people's
names are stored.
For example this table has a persons's first and last name.
Stars:
starID
starFirstName
starLastName
1
Vanna
White
2
Bob
Marley
problems begin to arise when people begin adding new names to the
table. I could make a unique key out of (starFirstName,starLastName)
but what happens when someone enters ('Robert','Marley') or
('Vanna','Wihte').
I guess the solution is to force users to do a query for an existing name.
Is there a way to do a more "fuzzy" search than using LIKE ?
would soundex or something else be the way to go?
--
Vincent Stoessel [EMAIL PROTECTED]
Linux and Java Application Developer
(301) 362-1750
AIM, MSN: xaymaca2020 , Yahoo Messenger: vks_jamaica
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
