[Resolved] [Resolved] Exporting data, and extracting?

[furious5]

Can anyone advise me on the best way I can acheive the following task.

Basically I want to export a table from my db, and extract a number of fields e.g date, price and put them in a table of there own.

There are over 300 records with 52 dates and 52 prices, so to go through the SQL dump file and put these in by hand is going to take hours!!!

I should say I am using PhpMyAdmin to interface with the db, I normally tend to dump the data and structure when exporting dump files, but in this case I don't think this is going to work.

[furious5]

Its ok, I've solved it!

Was being a bit thick, simply dumped the existing table. Created a new table from the existing structure, and dumped the fields I didn't want.