sql语句中加case

tlkj

如图所示，select值得源码是：
select t_phone_record.*
    from t_phone_record t_phone_record
    order by t_phone_record.timestamp desc




我现在想改成：
SELECT
        t_phone_record.*,(case phone_flg when 0 then '报修' else  '查活' end) as phonetype
FROM
        t_phone_record t_phone_record
ORDER BY
        t_phone_record. TIMESTAMP DESC



改后出错，请问如何实现我的需求?

jishuang

SELECT
        t_phone_record.*,(case t_phone_record.phone_flg when 0 then '报修' else  '查活' end) as phonetype
FROM
        t_phone_record t_phone_record
ORDER BY
        t_phone_record. TIMESTAMP DESC

tlkj

select p.*,(case when p.phone_flg = 0 then '报修' else '查活' end) as phonetype
    from t_phone_record p
    order by p.timestamp desc


报错

jishuang

queryAction中的idColumn设置为p

tlkj

好了，谢谢。结贴吧