Mysql Table Column Help

[codesguy]

I have a mysql table named songs with 3 columns, id, artist,title.

Most of the songs in the artist column are correct, ex:

artist
------------------
John Denver
Loretta Lynn
Shania Twain
Luke Bryan

But some of the songs in the artist column are reveresed with a comma, ex:

artist
-----------------
Dever, John
Lynn. Loretta
Twain, Shania
Bryan, Luke

Is there an easy php code snippet or mysql statement that i can use to reverse the order of first name and last name and remove the comma in the last example so the artst columd matches the first example?

I hope this makes sense, thanks, Dale.

[CroNiX]

It would be a lot better to store the first and last name separately, then format how you want on output.

[Barand]

Make a copy of your data (just in case) then try

UPDATE artist
SET name = CONCAT_WS(' ',TRIM(SUBSTRING_INDEX(name,',',-1)),TRIM(SUBSTRING_INDEX(name,',',1)))
WHERE INSTR(name,',');

 

[codesguy]

Thank you very much Barand! That worked Awesome!

 

Dale.