CASE WHEN的使用

Question

如图，我想得到一个新字段，值为

1DAY

3MINUTE

24HOUR

30MINUTE

17MINUTE

6HOUR

1DAY

请问各位师傅SQL应该怎么写

Answer 1

 SELECT CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(C_EXPRESSION, '*', 1),'/', -1), C_TYPE) from 表名;