mysql数据库，自定义排序查询

Question

select * from table
从table表中查询所有数据，按照 属性isable ==可用的排在前面，
isable==不可用排在后面，该怎么实现？

Answer 1

SELECT * FROM table WHERE isable = 1 ORDER BY isable ASC
或
SELECT * FROM table WHERE isable = 1 ORDER BY isable DESC
或
SELECT * FROM table WHERE isable = 1 ORDER BY isable ASC UNIQUE SELECT * FROM table WHERE isable = 1 ORDER BY isable DESC