SQL Query Question

I'm new to SQL, so please bear with me...

database = "users"
table = "info"
field = "name"

I have a situation where data in the "name" field is in the form of:
LastName, FirstName MiddleInitial.

I need to change it to the following form:
FirstName MiddleInitial. LastName

And then I need to update each row to fit the new form.

How can I do that in a SQL query?

I would really appreciate anyone's help or direction in finding out how to
do this.

Thanks,
Hobbster