MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

mysql Query that splits a string into various potions
Posted by: william Bamulanzeki
Date: July 27, 2016 04:14AM

I would like you to help me with a query that can split string of words into groups of two.
For example in a column i have 10 names, and these are of 5 people. They are separated by a space. So i would like an sql query that would split these names with a comma. Every after the second
[name1 name2 name3 name4 name5 name6,name7 name8 name9 name10]
output should be ==>name1 name2, name3 name4, name5 name6,name7 name8, name9 name10

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
mysql Query that splits a string into various potions
1519
william Bamulanzeki
July 27, 2016 04:14AM
Re: mysql Query that splits a string into various potions
920
Peter Brawley
July 27, 2016 08:49AM
Re: mysql Query that splits a string into various potions
805
william Bamulanzeki
July 27, 2016 08:57AM
Re: mysql Query that splits a string into various potions
829
Peter Brawley
July 31, 2016 01:24PM
Re: mysql Query that splits a string into various potions
945
Rick James
August 01, 2016 10:39AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.