I want to prevent duplicate records in a table but allow for blank/null values of those fields. It seems with a unique index, it includes null values.
So where I have email | phone fields in my table, and I want to allow a user add either or, the null values are considered a duplicate.