On Tuesday, April 17, 2001, at 11:00 AM, Devin Atencio wrote:
> I have a SQL Table that has over 1,000 records and I was wanting
> to write a script that would find duplicate phone numbers and
> then list the duplicate phone numbers. I have been trying to
> think on how to do this but I can't think of a way. Can someone
> please help me on some code I could write to do this?
I think you want something like this (MySQL syntax, YMMV):
SELECT phone_number, count(*) AS instances
FROM my_table
GROUP by phone_number
HAVING instances >= 2
ORDER BY instances DESC
This give you a list of all duplicated phone numbers, the number of
times they appear in the table, and sorts them with the most-duplicated
numbers first.
To list them, you just need to loop through the result set echoing the
phone number.
Cheers,
colin
--------------------------------------
Colin Putney
Whistler.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
