简单记录下指定参数排序mysql语法
有一批员工数据 employee_status 字典值为 (试用:1661 正式:1662 离职:1663)
要求:优先展示正式员工 其次试用 最后离职
SELECT
employee_status
FROM
staff
ORDER BY
field(employee_status,'1662') desc,employee_status asc;
简单记录下指定参数排序mysql语法
有一批员工数据 employee_status 字典值为 (试用:1661 正式:1662 离职:1663)
要求:优先展示正式员工 其次试用 最后离职
SELECT
employee_status
FROM
staff
ORDER BY
field(employee_status,'1662') desc,employee_status asc;