Rename Multiple Columns

How do you rename multiple columns in a MySQL database?

the same way you would a single column, but seperated with a comma. http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

But this doesn't work. It only allows you to rename only one column at a time. For example, if I want to change tow columns in a table called Members: name into FirstName and age into CurrentAge then:

ALTER TABLE MEMBERS CHANGE name FirstName CHAR(100), age CurrentAge INT;

This produces an error: however following two queries don't:

ALTER TABLE MEMBERS CHANGE name FirstName CHAR(100);

ALTER TABLE MEMBERS CHANGE age CurrentAge INT;

ALTER TABLE MEMBERS CHANGE name FirstName CHAR(100), CHANGE age CurrentAge INT;

Thanks, it's working like a charm. Took months to figure this one out.