Can i split one column into two column in MySql select query??
SELECT * FROM PRODUCT;
KEY| PRODUCT |CATEGORY
1 | trip |city
2 | trip |ocean
into
KEY| PRODUCT |CATEGORY1 |CATEGORY2
1 | trip |city |ocean
Asked
Active
Viewed 32 times
0
Ta Cho
- 1
- 2
-
1The term for this is pivot and if you search mysql pivot you will find plenty examples. – P.Salmon May 10 '20 at 06:49
-
That said, consider handling issues of data display in application code – Strawberry May 10 '20 at 07:08