[plug] [OT] MySQL Question....

[Timothy White]

Recently while designing a database, I discovered that only DB2 has a
"UNIQUE IF NOT NULL" for index's. MySQL does not. :(
I have the need for a 'unique or null' index. Setting the index to
Unique, treats NULL as a value, so I can only have 1 NULL value.

Anyone know how I might be able to do this? Or is it a case of having
to redesign that part of the database??

Thanks

Tim
p.s. I know this is OT, but I also know there are a lot of MySQL
brains on here, which should turn up better results that google is
turning up.
-- 
Linux Counter user #273956
Don't email joeblogs at scouts.org.au