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