Making mySQL entry unique using multiple columns

[stephan]

Hello!

I wonder if anyone can help me with this database question.

I am using phpMyAdmin to manage my databases. In one table I would like to have three columns (fields) to say whether the new entry is unique and should be stored or not.

In other words, the entry has to be different on at least one out of the three columns (fields) to be successfully stored in the database.

I would like to set this ruling in mySQL instead of using any PHP code. Anyone knows how to complete this task?

Field 1: "Price"
Field 2: "Date"
Field 3: "Store"

Thank you very much for taking your time helping! 😃

Best regards,
Stephan

[Pig]

AFAIK, there is no option to do this within MySQL. Postgre SQL may offer something for this, but I'm not sure.