MySql如何将查询的出来的字段进行转换

select *,
(case when ts.reciever like '%,%'  then '全部人员'  
 when find_in_set('1',  ts.reciever) then '渡口工作人员'
 when find_in_set('2',  ts.reciever) then '微信用户' end) as recieverName 
 from t_task_sms ts ;

select * from orders order by (mark+0) desc

CAST(value as type);
CONVERT(value, type);

select * from orders order by CONVERT(mark,SIGNED) desc
select * from orders order by CAST(mark as SIGNED) desc