Use SELECT COUNT(*), field FROM whateverdb GROUP BY field

The cnt_ column in the result will tell you how many times a data item is repeated in this field; a 2 obviously means a duplicated item, more than 2 means multiples of this item, 1 means singular instance of item. HTH. /psb