表中存在多个替换,
replace(replace(replace(replace(replace(字段名,"原内容1","新内容1"),"原内容2","新内容1"),"原内容3","新内容1"),"原内容4","新内容2"),"原内容5","新内容2")
现在想将剩余未进行替换的“原内容”全部替换成“其他”,应该怎么写?
思路,用decode 和 case when