JF,
You could try this, if I understand you correctly
=======
SELECT count(field_name), field_name
FROM table_name
GROUP BY field_name
HAVING count(field_name) > 1
=======
or HAVING count(field_name) = 2 , to find records that are in
there twice and no more than that.
Regards
**************************************************************
* K e i t h B u r k e *
**************************************************************
* Experience IT Ltd * Phone : +353 1 xxx xxxx *
* Unit G6 * GSM : +353 86 xxx xxxx *
* Riverview Business Park * Email : [EMAIL PROTECTED] *
* New Nangor Road * WWW : http://www.experience.ie *
* Dublin 12 * *
* Ireland * *
**************************************************************
-----Original Message-----
From: jf Leoni [mailto:[EMAIL PROTECTED]]
Sent: 06 September 2002 11:28
To: [EMAIL PROTECTED]
Subject: how to find double
hello,
i have a table with 10 500 000 rows on a mysql database
how can i find doubles ?? i know how to do it using php, but maybe
there
is a way using only queries?
tks
JF leoni
---------------------------------------------------------------------
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
