Simple Database Script To Remove Duplicate Listings

Title: Simple Database Script To Remove Duplicate Listings
Source: ScriptLance
Category: Database, Programming, Script, Simple
Posted On: Thu, 9 Feb 2012 06:02:54 GMT
Description:
I have a database of business listings containing name, address & zip code and category

I need a simple script that will recognize duplicate listing and among the duplicate listing keep the most recently imported listing and delete the rest.

The script has to look for several things to consider a listing a duplicate.

1. matching address
2. matching business title
3. matching category

This is the method I am thinking of but surely it will be refined in testing

The script will rem...
 
Share This Job:
Freelance Jobs

Recently Posted Projects:
Project Title Share
need logo designers
letter to request a salary increase on the basis of another job offer and current activites
e book
adult webcam software
Write an eBook about business
Wordpress GUI Tools - PSD's and/or Vectors
Wordpress Developer
Wordpress Design Development
Website Mock Up
Web Security Specialist
Tweets/Kikes/Followers
Social Media sales
Social Media Marketing
Slice and Code PSD File
Simple Payment page in Wordpress