On Monday 24 November 2003 03:25 pm, zzapper wrote: > Hi Y'All > > I need to test if any values in a column are the same (or are unique) > > eg (my made up syntax "Unique") > > SELECT * from tbl_addresses WHERE txtName is UNIQUE;
SELECT DISTINCT txtName from tbl_addresses; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]