[thelist] mysql regular expression query

Kevin thelist at lists.evolt.org
Mon Nov 11 11:24:02 2002


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