按条件里的部分优先排序
    SELECT *,(CASE buy_type
    WHEN ‘工程’ THEN 4
    WHEN ‘服务’ THEN 3
    ELSE 1 END
    ) s FROM zc_tb_plan ORDER BY s DESC