0

I am trying to implement splitting of a column into rows based upon a delimiter and I came across this.

Turning a Comma Separated string into individual rows

It describes a solution using SQL. Can anyone suggest a MySQL equivalent of this solution?

Community
  • 1
  • 1
Neha Arora
  • 49
  • 4
  • Either a) describe what the `STUFF` function actually does or b) ask the actual question for the problem you have (which appears to be splitting CSV data into separate rows) - who cares *what* function is used to solve it? – Damien_The_Unbeliever Oct 25 '16 at 06:29
  • You don't need the stuff function or a mysql equivalent (it doesn't do what you need). You can use the function from [MYSQL - Array data type, split string](http://stackoverflow.com/questions/4078838/mysql-array-data-type-split-string) to split up your array for the solution of your link. – Solarflare Oct 25 '16 at 06:58
  • Possible duplicate of [SQL split values to multiple rows](https://stackoverflow.com/questions/17942508/sql-split-values-to-multiple-rows) – Braiam Nov 30 '17 at 14:44

0 Answers0