a technique like this to locate the MySQL
data directory in scripts I run overnight to check the databases
and manage backups.
Steve Bacher
System Administrator
Draper Laboratory
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
This sounds like a good candidate for the two-table model:
Table 1 contains an ID and the basic names.
Table 2 contains the 1-many relationship of basic name entry mapped to
all the variants - one record per variant.
So you might have Table 1 containing
ID, Prefix, GivenNames, Surname, Suffix