Hello guys,

I want to combine 2 column with same total comma separator and add same string in the middle, anybody can help me how to do it?

column1 Column2 Column3
a,b,c,d 1,2,3,4

Output Table1

column1 Column2 Column3
a,b,c,d 1,2,3,4 a x 1,b x 2,c x 3,d x 4
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Apr 5 at 9:00
  • Virtually impossible in SQL; easy in PHP and many other languages.
    – Rick James
    Apr 7 at 22:36


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.