select case when function_order='23' then '232323' when function_order<5 then 'Small' else 'BigGGG' end as DDD, function_id as IDD, case when function_name='图书录入' then 'TSLR' else '~~~~' end as '~~', function_url as url from d_function where 1=1 +++++++++++++++++++++++++++++++++++++++++++++ DDD IDDD ~~ url Small 1 TSLR http://book.com Small 2 ~~~~ welcome/fun2.html Small 3 ~~~~ welcome/fun3.html Small 4 ~~~~ welcome/fun4.html BigGGG 5 ~~~~ welcome/fun5.html BigGGG 6 ~~~~ welcome/fun6.html BigGGG 7 ~~~~ welcome/fun1.html BigGGG 8 ~~~~ welcome/fun2.html BigGGG 9 ~~~~ welcome/fun3.html BigGGG 10 ~~~~ welcome/fun4.html BigGGG 11 ~~~~ welcome/fun5.html BigGGG 12 ~~~~ welcome/fun6.html BigGGG 13 ~~~~ welcome/fun1.html BigGGG 14 ~~~~ welcome/fun2.html BigGGG 15 ~~~~ welcome/fun3.html BigGGG 16 ~~~~ welcome/fun4.html BigGGG 17 ~~~~ welcome/fun5.html BigGGG 18 ~~~~ welcome/fun6.html BigGGG 19 ~~~~ http:// BigGGG 20 ~~~~ http:// BigGGG 21 ~~~~ BigGGG 22 ~~~~ http://jjjjjjjjjjjjjjjj.com 232323 23 ~~~~ http://dfdf