SQL case statement

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