Webmaster Forum - View Single Post

Musica · 07-17-2007, 02:34 AM

Hmm, not too sure which db you using assuming you are using mySQL, you can the following commands:

SELECT *, count(*) cnt FROM tableName GROUP BY fieldname1, fieldname2, .... HAVING cnt > 1

It will than return duplicates or entries with more than 1

If you using msSQL, you can read thier kb about this:
http://support.microsoft.com/default...b;en-us;139444

I also found this on softpedia, though personally I never use it before

http://www.softpedia.com/get/Interne...Software.shtml

07-17-2007, 02:34 AM	#6 (permalink)
Musica Contributing Member Join Date: 07-05-07 Posts: 128 iTrader: 0 / 0% Latest Blog: None	Hmm, not too sure which db you using assuming you are using mySQL, you can the following commands: SELECT , count() cnt FROM tableName GROUP BY fieldname1, fieldname2, .... HAVING cnt > 1 It will than return duplicates or entries with more than 1 If you using msSQL, you can read thier kb about this: http://support.microsoft.com/default...b;en-us;139444 I also found this on softpedia, though personally I never use it before http://www.softpedia.com/get/Interne...Software.shtml Last edited by Musica : 07-17-2007 at 02:39 AM.