Delete certain comma delimited data from column

Question

I have a column named Genre in my table that contains many various comma delimited content. The data is saved in different rows in this manner:

Adventure, fantasy, sandbox, RPG elements, 
Action, FPS, horror, 
Sports, Soccer,

I want to keep just the the first word in every row, and delete the rest. So only keep Adventure, Action, Sports.

Do not store data as csv. Learn about normalization. – Jens Sep 05 '20 at 18:34 — Jens, Sep 05 '20 at 18:34

score 0 · Accepted Answer · answered Sep 05 '20 at 17:52

0

You can use SUBSTRING_INDEX(str,delim,count) function to update the table column

update table set Genre = SUBSTRING_INDEX(Genre, ',', 1);

answered Sep 05 '20 at 17:52

dassum

1 Answers1