mysql case

select case name
when 'kabul' then 'k'
else 'other'
end as 'name' from city;

name
k
other
other
other
other
...