mysql中条件函数

SELECT *,IF(status='NOT_AUTH','NOT_AUTH',null) AS sort FROM `user` ORDER BY sort DESC

IF([条件],[为true时值],[为false时值])

SELECT *,( CASE WHEN STATUS = 'AUTHING' THEN 0 WHEN STATUS = 'NOT_AUTH' THEN 1 WHEN STATUS = 'HAS_AUTH' THEN 2 ELSE 999 END ) AS sort 
FROM
	`user` 
ORDER BY
	sort ASC

CASE
WHEN [条件1] THEN [条件1满足时值]
WHEN [条件2] THEN [条件2满足时值]
WHEN [条件3] THEN [条件3满足时值]
ELSE [条件都不满足时值]
END