data sorting from mysql database field

Cancelled Posted Jun 21, 2010 Paid on delivery
Cancelled Paid on delivery

We need someone to do some work using our database. We have a zip field in our database stacked with zip codes. We need someone to make a list of all zipcodes in the database. There must be no duplicates, so remove any duplicate zipcodes.

English zipcodes have this sort of format

PL20 8HJ or HA7 2BW.

So from there you would take it from PL20 8HJ to PL. Then write how many zipcodes there are that begin with PL etc.

Do this for all postcodes in the database. You will need coding skills as this is not a manual entry job as there are too many entries.

MySQL

Project ID: #718597

About the project

7 proposals Remote project Active Jun 21, 2010

7 freelancers are bidding on average $31 for this job

cygital

I can do it right now.

$30 USD in 0 days
(61 Reviews)
6.7
perlomonster

Please see the PMB!

$30 USD in 0 days
(23 Reviews)
5.7
kommandant

Experience !! Check your PM

$39 USD in 0 days
(9 Reviews)
3.8
hamm

I can start immediately.

$30 USD in 2 days
(11 Reviews)
3.8
fengyanliang

Hello, I know mysql and SQL language well, I am an experience programmer, I can do it for you, ready.

$30 USD in 1 day
(2 Reviews)
2.8
edbrown

Please see PMB, thanks.

$30 USD in 1 day
(1 Review)
1.0
monomobo

hi, please check your PMB for more information. Thanks

$30 USD in 1 day
(0 Reviews)
0.0