字段拆分
表notify a字段名attachment_id b字段名attachment_name
id attachment_id attachment_name
1 1302_191876432, 附件1.txt*
2 1302_98910528, 未标题-1.jpg*
我想得出
id mc
1 1302/191876432.附件1.txt
2 1302/98910528.未标题-1.jpg
[解决办法]
select id, replace(attachment_id, '_', '/')+replace(attachment_name, '*','') as mc
from notify
