-4

A single user having multiple tigs values in tigs column (Table 1 image). and want to show comma separated numeric value into row wise for every numeric value using mysql query? (Like Table 2). Table 1 Table 2

Muhammad Khurshid
  • 21
  • 8
  • 1
    Please put some efforts in framing a question with **relevant and minimal sample data** showcasing your requirements, and **corresponding expected output**. Please read this link: [Why should I provide an MCVE for what seems to me to be a very simple SQL query?](https://meta.stackoverflow.com/q/333952/2469308) – Madhur Bhaiya Nov 26 '18 at 10:28

1 Answers1

-1

If you need to display separately then why stored with comma separated. There is no MySQL function which explode values and join internally with table to produce Cartesian result. If you take table join of tigs fields then it is possible.

Sunny Patel
  • 59
  • 2
  • i have a seperate table named: tigs where tigs informations are stored. and for every user we are assigning multiple tig codes, but now we want to show every tig seperately – Muhammad Khurshid Nov 26 '18 at 11:06