sql语法 --- 当值为0时显示否，1时显示是

select
bankcardid,
bankname,
case
when isdefault=0 then '否'
when isdefault=1 then '是'
end as isdefault
from u_bankcard
where memberid=1001