[thelist] mysql regular expression query

[Kevin]

Hello,

I have a column in a mysql table with a name of a person, say "Franklin D.
Roosvelt". Can I
query the table so that the name will be retrieved in the following format:

Roosvelt, Franklin D.

Any help will be appreciated.

--Kevin