mysql - 查询多个where条件

Question

希望有人能帮助我理解为什么第一个查询有效而第二个查询无效。我的目标是首先显示状态为“关闭”的行，然后显示状态为“等待”的行

 "SELECT *  from job WHERE status='close' AND status='wait' ";

 "SELECT *  from job WHERE status='close ";

我尝试这样做是可行的，但我想显示除“已删除”之外的所有状态

$sql = "SELECT id,date, device,model,problem,status,assigned  from job  ORDER BY FIELD(status,'deler_trenger','deler_bestilt','new','progress','wait','done','close','cancel')";

Answer 1

在 status<>'deleted' 中使用 where 条件

SELECT id,date, device,model,problem,status,assigned  from job  
where status<>'deleted'
ORDER BY FIELD(status,'deler_trenger','deler_bestilt','new','progress','wait','done','close','cancel')