MySQL Forums
Forum List  »  Newbie

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

Hi

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?

Sincerly
Steen

Options: ReplyQuote


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


Sorry, only registered users may post in this forum.

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.