Chris Knipe wrote: >Multiple subnets :/ > >columns like this: >octet1, octet2, octet3, octet4 >195,196,192,23 >232,196,231,11 > >This would then be seen as a duplicate
Not if you have a single index spanning all four columns (as opposed to four indexes, one on each column). With the single index, individual columns can contain values that are duplicated in other rows as long as the combination of values is unique. -myk -- [sql, mysql, query] --------------------------------------------------------------------- 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
