I have a series of queries / updates that I would like written on my database.
The database consists of restaurant information with things like -
Name of restaurant, address, city, state, zip, phone etc.
However, the sources of the data often provide the information differently so we get phone numbers that look like 214-111-1234 and (214)111 - 1234 and [url removed, login to view] and we would like them all to be consistent.
In addition, we have a number of duplicate records in the database that need to be removed. We are looking for a way to identify them and delete them.
We have a series of "close match" items where we think they are duplicates, but we would have to review them. Things like 14201 Dallas Parkway and 14201 Dallas Pkwy.
This bid would be for a series of queries / clean up activities. For someone who knows what they are doing this should be very easy work.
There are a number of "housekeeping" reports that we would like built after this first task is completed.
Please bid on provide me 10 SQL queries to do items described above.
My preference is for me to provide you with the table names and their elements and samples of the data, but not give you access to the database. If that is too difficult then we can evaluate access.
32 freelancers are bidding on average $75 for this job
This is one-shot editing..... so the efficiency of MySQL queries ONLY is not needed. Also, you want to keep your database private. See PM for a nice solution to your problem.