请问一下，我想批量更新一个字段里面的内容，改成我标注的这样，如图，sql应该怎么写

Question

Answer 1

UPDATE CM.CELL_SF_DW_NEW set TECHNOLOGY= 
case when TECHNOLOGY= 'GSM' then '2G' 
when TECHNOLOGY= 'TD' then '3G'
when TECHNOLOGY= 'LTE' then '4G'
when TECHNOLOGY= 'NR' then '5G'
when TECHNOLOGY= 'NB' then '5G'
else TECHNOLOGY
end;