strSQL = "select sms_id, content, status, case status when '03' then 0 else 1 end as isRead from sms where (available=1) order by isRead, sms_id"
对于case status when '03' then 0 else 1 end as isRead这句话不理解,我这儿没有中文帮助,请知道的同胞给我解释一下,非常感谢!
...全文
662打赏收藏
请问这句SQL是什么意思?
strSQL = "select sms_id, content, status, case status when '03' then 0 else 1 end as isRead from sms where (available=1) order by isRead, sms_id" 对于case status when '03' then 0 else 1 end as isRead这句话不理解,我这儿没有中文帮助,请知道的同胞给我解释一下,非常感谢!