php - 选择自定义结果

Question

我在数据库中有:

City:
id | name       | type
1  | London     | A
2  | Manchester | E
3  | Cardiff    | W

我想通过选择接收:

1  | London     | First
2  | Manchester | Second
3  | Cardiff    | Third

所以查询应该将 A 替换为 First，E 替换为 Second，W 替换为 Third。

SELECT id, name, type ???? FROM City

我怎样才能做到？

Answer 1

select id,
       name,
       case when type = 'A' then 'First'
            when type = 'E' then 'Second'
            when type = 'W' then 'Third'
       end as alias_name
from City