SQL case statement
selectcase 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 urlfrom d_function where 1=1+++++++++++++++++++++++++++++++++++++++++++++DDD IDDD ~~ urlSmall1TSLRhttp://book.comSmall2~~~~welcome\fun2.htmlSmall3~~~~welcome\fun3.htmlSmall4~~~~welcome\fun4.htmlBigGGG5~~~~welcome\fun5.htmlBigGGG6~~~~welcome\fun6.htmlBigGGG7~~~~welcome\fun1.htmlBigGGG8~~~~welcome\fun2.htmlBigGGG9~~~~welcome\fun3.htmlBigGGG10~~~~welcome\fun4.htmlBigGGG11~~~~welcome\fun5.htmlBigGGG12~~~~welcome\fun6.htmlBigGGG13~~~~welcome\fun1.htmlBigGGG14~~~~welcome\fun2.htmlBigGGG15~~~~welcome\fun3.htmlBigGGG16~~~~welcome\fun4.htmlBigGGG17~~~~welcome\fun5.htmlBigGGG18~~~~welcome\fun6.htmlBigGGG19~~~~http://BigGGG20~~~~http://BigGGG21~~~~BigGGG22~~~~http://jjjjjjjjjjjjjjjj.com23232323~~~~http://dfdf
页:
[1]