MySQL-出现时替换字符串

“PrizeMoneyBreakDown”列包含许多由分号分隔的字符串。我试图从数据中删除字符串“总值”、“奖杯总值”和“福利基金”。这些字符串有时只出现在数据中,所以它不像删除最后三个字符串那么简单。我需要写一个删除字符串的查询 如果 它们出现了。

数据示例:

1st,5285;2nd,1680;3rd,885;4th,550;5th,350;6th,350;7th,350;8th,350;total_value,10000;welfare_fund,200;trophy_total_value,150;

所需的数据输出:

1st,5285;2nd,1680;3rd,885;4th,550;5th,350;6th,350;7th,350;8th,350

当前代码(仅删除单词“总值”等-不删除与字符串关联的奖金):

SELECT PrizeMoneyBreakDown,
  REPLACE(REPLACE(REPLACE(PrizeMoneyBreakDown,'total_value',""),'welfare_fund',""),'trophy_total_value',"") as new
FROM race2;