Thinking about his very briefly, I suspect you need two tables and a flag.
The first table would be something like
person:
===
person_id
names:
==
person_id
is_primary_name (Boolean)
name
For each person, you'd have one or more names with the one you want as the
"working" name flagged.
Ian M. Evans wrote:
I'm trying to wrap my head around dealing with people in a table that
have multiple names or akas.
I run an entertainment news site and have to deal with people like
Pamela Anderson (who was once Pamela Lee, Pamela Anderson Lee, Pamela
Denise Anderson), Eva Longoria (who's