mysql - 选择条件 1 在条件 2 之后的记录

Question

在我的项目中，我有类似的查询。

$mainquery="SELECT * 
            FROM project 
            WHERE ProjectType='Current Projects' and Status='In Progress' 
            order by projectid";

和

$mainquery="SELECT * 
            FROM project 
            WHERE ProjectType='Current Projects' and Status='Not Started' 
            order by projectid";

现在我想将两者结合起来，并希望所有 Status='In Progress' 和 Status='Not Started' 的记录。我试过了。

$mainquery="SELECT * 
            FROM project 
            WHERE ProjectType='Current Projects' and (Status='In Progress' or Status='Not Started') 
            order by projectid";

但它给出了 Status='In Progress' 和 Status='Not Started' 的组合结果。我首先想要 Status='In Progress' 的所有记录，然后是 Status='Not Started' 的所有记录。

Answer 1

这些内容可能会有用

SELECT * 
      FROM project 
      WHERE ProjectType='Current Projects' and (Status='In Progress' or  
      Status='Not Started') 
      order by case when Status like 'In Progress' then 0 else 1 end, Status

编号:https://dba.stackexchange.com/questions/96446/mysql-order-by-first-condition-in-where-clause