mysql - 使用大小写更改值

Question

我正在迁移一个数据库，我需要将一个整数列更改为字符串格式的相关类别。我如何检查每个值并使用 ifelse 或 switch/case/break 即时更改它？

SELECT *, Category FROM Members
  Category =
  Switch(category)
  if (value == 1 then change to "Category 1", value == 2 then change to "Category 2 and so on.)

Answer 1

SELECT *, case when category = 1 then 'Category 1'
               when category = 2 then 'Category 2'
               else 'Category unknown'
          end as category
FROM Members