I have a table with peoples names in 3 different languages.
Fields are like: id, surname_english, name_english, surname_original, name_original, surname_greek, name_greek.
What I want is to check if a person has been entered twice in that table.
You can create unique index on (surname_english, name_english) and others... UNIQUE KEY unique_key_name (surname_english, name_english)
Ivan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
