I gang

Mysql db update - One field for about 1500 records

Hi. I have a mysql db but am a little nervous about trying this myself even though I'm ok at different types of geekery.

I have an address field (with data like 3 Smith Street Sydney NSW 2001 AUS) and I need the corresponding zipcode field filld (currently it's an empty text field.) so it will be 2001.

So I'm guessing the query would be along the lines of >> if address is "3 Smith Street Sydney NSW 2001 AUS" update zip-field to "2001" or whatever the proper syntax would be.

There is access to the database via phpmyadmin. I can create a csv file with the two fields or however you want the data.

Am guessing this would take an sql pro less than half an hour. Would you be interested.

I'd need this done today or tomorow if possible.

many thanks

Færdigheder: MySQL

Se mere: sydney nsw, mysql db, it field, db query, sql update text, sql update field text, update sql file, csv update, aus file, update text sql, sql update text field, mysql update field, mysql update database, 1500 mysql, update field sql field field, sql update text text, mysql sql syntax, mysql empty database, query text mysql, mysql stock database import csv, phpmyadmin mysql, phpmyadmin csv update, csv phpmyadmin, sql query field, data want create mysql

Om arbejdsgiveren:
( 15 bedømmelser ) 2007, Australia

Projekt-ID: #6049492

Tildelt til:

solutionsauzlx

Hired by the Employer

$30 AUD på 1 dag
(32 bedømmelser)
5.6