MySQL Forums
Forum List  »  InnoDB

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

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql Query that splits a string into various potions
799
July 27, 2016 04:14AM


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.