Can anyone help me construct a MySQL command that will look at a column (in my case name) and select the last name out and leave the first name in the column and then add the last name to a different column.

The structure of the name column is: lastname, firstname

I would like the name column to keep the firstname but put the lastname into a new column already defined as lastname. (without the comma)