SOLVED: Need help from MySQL knowers (Not MODx related)

This is not a MODx questions, and I have asked the question in MySQL forums, but have not yet received a response. Here I have always got answers, so I take the chance to ask the question here too:

Is it possible in MySQL and retrieve data from a row and put it into another row? I have a field called Name in a MODx table, with data in the form Firstname Lastname. I need to put this into another row as Last Name, First Name, and as Firstname in a separate field and Lastname in another field. Is this possible via SQL?

That way I avoid having to change the 2000 fields manually.

Thanks.

you can try:

Thanks . It works!