I have a field having values like
ID, Value
----------
1 ,Camera,photography,song
. I want to split this to
ID, value
----------
1, Camera
1, photography
1, song
How can i accomplish this in mysql Database
Asked
Active
Viewed 19 times
0
Salini L
- 829
- 5
- 15
- 43
-
ya I knw. Is there any method to explode these – Salini L Jun 11 '18 at 09:51
-
1Poor database design? Reconsider a normalized structure that would be much more effective than finding a quick workaround. – revo Jun 11 '18 at 09:53
-
@revo To be fair, that appears to be the direction in which the OP is heading. – Strawberry Jun 11 '18 at 10:29