业务逻辑 SELECT * FROM table ORDER BY CASE WHEN IFNULL ( field1, '' )= '' THEN 0 ELSE 1 END DESC, field2 DESC; 一批设备绑定个人,设备有顺序,绑定过的设备会优先在上方显示