you should make a self-join to find the duplicates in one table. -----Original Message----- From: Jean Fabrice Leoni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 2:00 PM To: [EMAIL PROTECTED] Subject: find double
hi, i have a mysql table with 10 millions rows. Response time is perfect, but i have some duplicated entries inside ... (maybe 100 - 200 rows) how can i find them using only SQL ? i can do it with php but really don't know if it is possible using only a SQL query ... best regards. Jean-Fabrice Leoni AXSMARINE Paris Cyber Village 204 rue de Crimée 75019 Paris --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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