mysql 根据指定值排序
select *
from `jumin`
where jumin_house_id=$house_id
order by (case when jumin_quanshu='自有' then 1 when jumin_quanzhu='租赁' then 2 else 99 end)
,(case when jumin_chanquan='人本' then 1 else 99 end)
select *
from `jumin`
where jumin_house_id=$house_id
order by (case when jumin_quanshu='自有' then 1 when jumin_quanzhu='租赁' then 2 else 99 end)
,(case when jumin_chanquan='人本' then 1 else 99 end)