[thelist] mysql: unique constraing and null default

[Aleem Bawany]

I have an email entry field, which is optional and hence can be left
blank. I want the field to be unique so no two users can have
dupes, but I want them to be able to leave it blank so the field
can be null and the default is null. I can't impose a unique
constraint, however, because then two rows can't be empty
(then they'll be dupes).

What should I do? (this sql biz is no fun)

aleem

[ http://aleembawany.com/ ]