(RADIATOR) Duplicate accounting records - MySQL

[Robert Mann]

What is the easiest way to address this problem with MySQL.  I am working on a companies Radiator server that uses MySQL as its database server for accounting and there are many duplicate records.  In MS SQL it was easy as I could use a constraint that would prevent it from happening but it is my understanding that MySQL does not have this functionality.  If I am wrong please right me and give me an example.  If I am right then how do you work around this problem?   Thank you, Robert Mann Senior Systems Administrator OneMain.com