MySQL remove duplicate Phone Numbers

[chasejordan1]

I have been searching for a command to use to remove all duplicate phone numbers within my system and am having a very difficult time, I have about 12 different list and I don't want the agents calling the same phone numbers. My list girl didn't not select "remove duplicates" when she imported the lists. I don't want to have to export each list then import again. Any ideas on how to do this with a single command. Thanks

[covarrubiasgg]

I AM NOT RESPONSIBLE FOR ANY DATA LOSS, TRY IT UNDER YOUR OWN RISK

You can create a new empty list for example 123123

Code: Select all

/usr/share/astguiclient/VICIDIAL_DEDUPE_leads.pl --live-update --system-duplicate --duplicate-list=123123

You can check more options for the script here

Code: Select all

-- VICIDIAL_DEDUPE_leads.pl --

This program is designed to scan all leads for a campaign or entire system that are duplicates and move the newer lead into a different list_id.

allowed run time options:
  [-q] = quiet
  [-t] = test
  [--live-update] = runs the live UPDATE to move leads, default is report only
  [--system-duplicate] = checks for duplicates in entire database
  [--campaign-duplicate=1234] = duplicate check witin this campaign
  [--ignore-list=999] = ignores the list in duplicate check
  [--duplicate-list=998] = list_id that duplicate leads are moved to, default is 998
  [-h] = this help screen

[sohail2542]

Good it is working perfectly, thanks for help