MySQL Forums
Forum List  »  Newbie

Reverse comma seperated field
Posted by: Steen Thunberg
Date: August 23, 2017 06:18AM


Need som help to reverse a comma-seperated text-field in all records in a Mysql-database.

The text-field look like:
"Country, County, Area, local-area"

I want them all changed into:
"local-area, Area, County, Country"

There may be from 1 up to 6-7 items in the string. All seperated with commas...

Can anyone please help me with a script to use in the phpMyAdmin?


Options: ReplyQuote

Written By
Reverse comma seperated field
August 23, 2017 06:18AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.