[thelist] mysql regular expression query

Kevin lists at irubin.com
Mon Nov 11 11:24:02 CST 2002


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.


More information about the thelist mailing list