[thelist] mysql regular expression query

[Kevin]

> I'm sure there is a way to do this; I've heard SUBSTRING() SQL function
may
> be of some use
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_
> setu-sus_6btz.asp (watch the word wrap).
>
> I've also heard that their really isn't an official "split" function
> available but SQL does come packed with SQL string functions. The way I'd
do
> it with my little diverse knowledge of SQL, is I'd grab the cell contents,
> and if the naming convention was the same (i.e. First Middle. Last), split
> the recordset value up by the space delimeter, and finally rearrange the
> results for the user.
>
> Try Microsoft's solution though,
>
> Rob.Smith
>
=============
> 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
>
>

I am looking for a mysql solution. Thanks for your help, though.

K