Hi, is it possible in the mySQL to have an index that none of the values could be repeated except for a single value that could be repeated? The values of the column would be something like this
'123' '245' '233' 'XXX' 'XXX' '027' where just the value XXX could be repeated. Thanks, Andre __________________________________________________ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php