SQL 选择布尔选项

Question

抱歉，标题含糊不清，但我不确定如何用一句话来解释我想做什么。

序言： 选择布尔列的 SQL 语法如下：

SELECT MyBooleanColumn FROM MyTableThatHasABooleanColumn

这会产生以下结果：

MyBooleanColumn
===============
       1
       1
       1
       0
       1
      ...

问题： 有没有办法获得以下结果？

MyBooleanColumn
===============
     True
     True
     True
     False
     True
      ...

Answer 1

是的，这样做：

SELECT 
case when MyBooleanColumn = 1 then 'True' else 'False' end as MyBooleanColumn 
FROM MyTableThatHasABooleanColumn

Answer 2

SELECT case when MyBooleanColumn = 1 then 'True' else 'False' end as MyBooleanColumn  
FROM MyTableThatHasABooleanColumn

Answer 3

SELECT case 
        when MyBooleanColumn = 1 then 'True' 
        else 'False' 
    end as MyBooleanColumn  
FROM MyTableThatHasABooleanColumn