mysql语句排序问题?

[hilivivi]

请问下中文的数字怎样实现排序？比如像一组，二组，三组，四组…………怎样使用mysql语句进行升序排序？

[不穿内裤的超人]

with cte(id,zs) as (
select 101,'一组' union
select 102,'三组' union
select 103,'二组' union
select 104,'四组' union
select 105,'二组' union
select 106,'一组' union
select 107,'八组' 
)
select * from cte order by 
case zs when '一组 ' then 1 
when '二组' then 2 
when '三组' then 3 
when '四组' then 4 
when '五组' then 5 
when '六组' then 6 
when '七组' then 7 
when '八组' then 8 
when '九组' then 9 end

[中国风]

 select 
 *
 from (
select 101 as Col,'一组' as Col2 union
select 102,'三组' union
select 103,'二组' union
select 104,'四组' union
select 105,'二组' union
select 106,'一组' union
select 107,'八组' 
)t
order by  locate(left(Col2,1),'一二三四五六七八九十') asc

[等不到来世]

比较现实的做法是加一个int型排序列。