mysql查询结果按指定顺序排序

select distinct A.chatType, NO_FILTRATE.empName, A.Chatting from T_NAM_ChatMonitor A, T_SC_UserManager NO_FILTRATE where A.pcName = NO_FILTRATE.pcName  and DATE(A.dateTime) >= '2011-07-12'  and DATE(A.dateTime) <= '2011-07-12'  order by  FIND_IN_SET(A.ChatType, 'QQ/TM,MSN,skype,UC,飞信,RTX,阿里旺旺') , convert(NO_FILTRATE.empName using gbk), convert(A.Chatting using gbk) limit 0, 20