mysql find_in_set排序

select distinct new_payType from 
(
select * from g_zy_erp_contract_hkzq
limit 1000
)a
order by FIND_IN_SET(new_payType,'一次性付款,商业贷款,公积金及组合贷款,首付分期,全款分期')

-- 数字高位用0补齐
RPAD(STR,LEN,PADSTR)
LPAD(STR,LEN,PADSTR)

SELECT LPAD(MONTH(NOW(),2,'0'))   -- 02