Suppose, there is a table called sometbl and has the following data into it.

Therefore for (2), example rows would look like >> “3, white”, “3, Snow” …

Example

Usage

Output

mysql procedure to split column values

Thanks for reading.

Software Professional, I am passionate to work on web/enterprise application. For more information please go to about me. You can follow on Twitter. You can be a friend on Facebook or Google Plus or Linkedin

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.