I know the answer is going to be blindingly obvious, but for the life of me, it is escaping my tired old mind.
I need to store customer details in a MySQL database. Although primary access will be through a unique system-generated auto-incrementing key, customer access will be via the email address. However, the table contains records for which we have no email address. So, how can I create a unique key on the email field to prevent duplication when various records have null values in that field?
Any help will be much appreciated. Thanks!