select case when H=1 then ‘在售‘when H=2 then ‘售完‘ endas H from HHselect * from HH--case when then endselect HID，case H when 1 then ‘在售‘when 2 then ‘售完‘ end as HHu from HH
数据库在中显示1或2，在程序中代表不同状态
原文：http://www.cnblogs.com/zeng-qh/p/7354449.html
