Em Andamento

MySQL - Queries and Reports

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.

Habilidades: PHP, Shell Script, SQL

Ver mais: sql get duplicates, php dallas, names numbers, mysql data access, mysql city state database, dallas php, things like, my reports, access dallas, sql reports, sql queries, sql mysql, sql duplicates, queries, housekeeping, delete duplicate, database queries, duplicate table, mysql delete, mysql number sql, housekeeping database, access clean data, queries database, mysql review, mysql delete duplicate

Acerca do Empregador:
( 28 comentários ) Allen, United States

ID do Projeto: #589919

Premiar a:

festsoft

Please see PM. David Johnson, Durham England

$50 USD em 2 dias
(17 Avaliações)
4.9

32 freelancers estão ofertando em média $75 para este trabalho

agilesols

WE CAN DO IT.

$50 USD em 1 dia
(209 Comentários)
7.5
DesignSolutionSW

Please check PM.Thanks.

$30 USD em 1 dia
(64 Comentários)
7.0
eperfections

Please see PM.

$35 USD in 2 dias
(228 Comentários)
6.9
yunuscse

Query specialist here! Please check PM.

$65 USD in 2 dias
(97 Comentários)
6.6
jeevanoss

Pls see the PMB

$30 USD em 1 dia
(37 Comentários)
6.3
gangabass

I can do this job for you. See PM for details.

$30 USD em 1 dia
(127 Comentários)
5.9
MAST3R

You have PM

$40 USD in 0 dias
(12 Comentários)
5.6
athenainc

Database specialists here. Please check PM for details.

$70 USD in 4 dias
(4 Comentários)
5.6
offacc

Hi, Please check PM for details. Thanks

$60 USD in 2 dias
(45 Comentários)
5.1
servicebenq

check your pm please. thanks

$30 USD in 0 dias
(37 Comentários)
5.1
itliveweb

Please see PMB.

$100 USD in 3 dias
(9 Comentários)
4.6
sat12345

Plz check PMB...

$70 USD em 1 dia
(51 Comentários)
3.9
amsak

Pls see PM

$30 USD in 7 dias
(7 Comentários)
3.4
DanielNikolov

Hello, I have experience with MySQL and I have done similar job for a telecommunication company in Bulgaria (but not as freelancer). About your problems: 1. The duplicate records can be removed by sql query, which c Mais

$50 USD in 2 dias
(2 Comentários)
2.8
suryavikas

Hi, I work for a top MNC and we do this kind of job on a daily basis, I have better solution in mind, idea is to provide you an entire backend job(written in Talend) which you can reuse from the command prompt and Mais

$200 USD in 7 dias
(1 Comentário)
1.6
klpsoftware

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.

$50 USD in 7 dias
(0 Comentários)
0.0
glargo

Hi andydeshong, The first thing that you need to do is the data clean up, then the standardize it and at the end you must create software validation to the new data entry. If you wish we can start to work in the da Mais

$100 USD in 5 dias
(0 Comentários)
0.0
intensecoder

Except that part of 'housekeeping' reports, I can do rest of the things for $30. I am a 3.5 years experience holder web developer in PHP/MYSQL and ASP/MSSQL. Please view [url removed, login to view] and [url removed, login to view] Mais

$30 USD in 4 dias
(1 Comentário)
0.0
manishrma

Hello, Please see PM. Thanks, Manish Chander

$250 USD in 30 dias
(0 Comentários)
0.0
metal333

Hii... I have done many projects on SQL.I am sure I can do your work too.

$33 USD in 3 dias
(0 Comentários)
0.0