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.