I have a table full of data, where one column is full of different entries for each row, where the data is formatted like this: A:some text|B:some other text|C:some more text| I want to separate those strings of text into two columns on a new table. So the new table should have one column for A, B, C etc. and the other column will have the rest of the text in their respective rows. And there is another value (a DATETIME value) in a separate column of the first table that I would like to copy into a third column for each of the separated entries.

Bu clarificaiton ihtiyacı varsa bana bildirin, ben bu tür kafa karıştırıcı olduğunu biliyorum ve ben MySQL ile oldukça bulanık. Teşekkürler!