mysql - SQL 更改结果

Question

所以我有这段代码，它工作正常

SELECT NAME, 
       Country, 
       NORMAL_STATE, 
       CURRENT_STATE
FROM SOMS_TABLE
WHERE SOMS_TABLE.NAME LIKE 'AR%' AND 
      NORMAL_STATE <> CURRENT_STATE
ORDER BY SOMS_TABLE.Country ASC

输出是


但我想将 1 和 0 更改为 OPEN & CLOSED


谢谢

Answer 1

select name,
    Country,
    case NORMAL_STATE
        when 1 then 'OPEN'
        when 0 then 'CLOSED'
        else 'UNKNOWN'
    end as NORMAL_STATE,
    case CURRENT_STATE
        when 1 then 'OPEN'
        when 0 then 'CLOSED'
        else 'UNKNOWN'
    end as CURRENT_STATE
from SOMS_TABLE
where name like 'AR%'
    and NORMAL_STATE <> CURRENT_STATE
order by Country