mysql - split one or more record from a colums record with specific element -

I will explain myself a little better: I am contrary to the tragedy that a programmer is facing in front of me. There is a field called a title which is divided by more tags than the inside comma, I need the id field of record, divide the strings and two or multiple records with the ID taken by each primary key and coma Receive.

I insert a screen of the situation Can you help me?

Use the SUBSTRING_INDEX function. SUBSTRING_INDEX ('Kodak Box, EduNeto Preezy', ',', - 1) ASA, SUBRITITIINXX ('Codice Exploies'), select the code as 'Selection' , 'AdMenanto Prize', ',', 1)

Output

  + --------------- ------------ --------- + -------------------- + ------- --------- + | Field | Parta | | Partb | + ------------------------------------ + ------------ - + ----------------------- + | Kodis Aptty, EduGomento Prize. Edigando Prezhi | Kodis Applicability | + ------------------------------------ + ------------ -------- + ---------------- +