Originally Posted by teksonline

you need database experience or a database admin to do these tasks for you, its a simple but multi-step proccess

connect to mysql client.. if you have shell access to server you can do something like

echo "SELECT field1, field2, field3, field4 FROM <tablename>"|mysql -u<username> -p <databasename> >filename.txt

this will put all those records into filename.txt, then load into spreadsheet selecting proper formatting, might be a space or tab, between fields, i forget
offhand

you need to include the primary key field in your selects so when your done you can use the following commands to re-import

UPDATE <tablename> SET field2 = 'blah', field3 = 'blah' field4='blah' WHERE field1 = 'ID'; based off a written script of some sort that is reading the text file line by line