大致思路: 拼一bai个字符:规定时du间zhi内:字dao符1开始,后面连接a时间之外zhuan:字符2开始,后面连接b具体shu语法你修改:order by ( case when time >=1338048000 and time <= 1338307200 then '1'+a else '2'+b end )