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.
The key is ID but I can't have any other field unique, as names and surnames are not unique.
I only want the combination of two fields of the same language to be unique.
How can I check this?
Any possible solution?



-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to