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)

posted on 2022-09-09 11:00  小馬過河﹎  阅读(24)  评论(0)    收藏  举报

导航