mysql指定某一字段中的 某一个值排序在最前面

SELECT * from project where project_status=2 order by (case when task_progress=“招标” THEN 1 when task_progress=“等待确认” THEN 2 when task_progress=“工作中” THEN 3 else 4 END),pk_project_id desc

https://blog.csdn.net/mm_ling/article/details/88691195