select *,tt = case tui when 1 then '推荐' else '' end from 表名
转载于:https://www.cnblogs.com/AquariusXinXin/archive/2009/12/28/1633832.html
select *,tt = case tui when 1 then '推荐' else '' end from 表名
转载于:https://www.cnblogs.com/AquariusXinXin/archive/2009/12/28/1633832.html