mysql CASE WHEN

SELECT 
 case when built_area < 100 then 1
when (300>=built_area and built_area>=100) then 2
when (500>=built_area and built_area>=301) then 3
when (700>=built_area and built_area>=501) then 4
when (900>=built_area and built_area>=701) then 5 
 when built_area>1000 
then 6  end 级别 ,
SUBSTRING_INDEX(area,'-',1)
 district ,province,city ,built_area FROM `sm_store_datas`  ORDER BY built_area ASC

case when 等价于java php 中的 switch