mysql_crud

多分支查询

SELECT 
(CASE WHEN (marketprice > 0.1 and marketprice < 2) then marketprice + 1       
WHEN (marketprice > 2.1 and marketprice < 5) then marketprice + 3  
WHEN (marketprice > 5 and marketprice < 10) then marketprice + 5  
WHEN (marketprice > 10 and marketprice < 20) then marketprice + 10 
WHEN (marketprice > 20 and marketprice < 30) then marketprice + 18
WHEN (marketprice > 30 and marketprice < 50) then marketprice + 30   
WHEN (marketprice > 50 and marketprice < 100) then marketprice + 40  
else null end) AS  marketprice 
from ims_ewei_shop_goods;

mysql_crud

标签：ase   from   col   class   price   highlight   else   多分支   mysq