Re: Finding Duplicate Numbers?

On Tuesday, April 17, 2001, at 12:19 PM, Mark Maggelet wrote:

That works for mysql. He probably just wants to kill the duplicates, so there's an easier way: add a unique index to the phone_number field. alter ignore table $table add unique (phone_number);

Yep, that will prevent duplicate phone numbers from being inserted into the table. Note that if there is existing data in the table, he'll have to remove the duplicates before making the phone_number field unique. Cheers, colin ----------------------------------------------------------------- Colin Putney Whistler.com