RE: how to find duplicate fields

It depends a bit on what you actually want to do with the duplicates but if you are just interested in knowing if you have some then the following should do the trick.

SELECT Name, COUNT(*)
FROM MyTable
GROUP BY Name
HAVING COUNT(*) > 1 This will give a list of names that occur more than once with a count of how many of each there are.

John Bonnett

-----Original Message-----
From: ROMEO PETRUCA [mailto:rpetruca@yahoo.com] Sent: Monday, 29 October 2007 6:29 PM
To: win32@lists.mysql.com
Subject: how to find duplicate fields

table:

Code int 7
Name char 30

need to find duplicate fields for field name. any ideas please !

Romeo Petruca
George Enescu 16/13
Hunedoara
Romania
tel: 0720301842/0354401534
e-mail: rpetruca@yahoo.com, rpetruca@gmail.com

-- 
MySQL Windows Mailing List
For list archives: 
http://lists.mysql.com/win32
To unsubscribe:    
http://lists.mysql.com/win32?unsub=lists@pantek.com

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek