Is there a way of creating a unique 'group' of fields within a MySQL table?
For example, take an address book.
There will be fields like user id (the owner of the address) and post code. Is there a way of grouping the user id and the post code together to ensure that that user doesn't add that address again?
Also, the user must be allowed to enter multiple addresses so the user id will appear multiple times.
Any help would be appreciated.