当性别以布尔值形式存储在表中时，MySQL将性别提取为字符串

Question

我有一张叫accounts的桌子。我有一个名为gender的列，它的数据类型是Boolean。

我想在我的select query中以字符串的形式直接获取性别。如何在MySQL中实现这一点？

Answer 1

MySql支持标准的SQL CASE语句。MySQL还具有较短但非标准的IF语句

SELECT IF(gender,'MALE','FEMALE') as gender from accounts

Answer 2

您可以使用case when expression

select *, case when gender=false then 'Female' else 'Male' end as gender
from tablename

Answer 3

select gender,IF(gender=1,"Male","Female") as gender2 from accounts