Query with multiple where conditions

Question

hope someone can help me to understand why this first query works while the second one does not. My goal is to show first the row with status "close" and then the row with status "wait"

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

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

I attempted to do this which is working but i want to show all status except "deleted"

$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')";

Fahmi · Accepted Answer · 2019-03-14 11:17:28Z

1

Use where condition with status<>'deleted'

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')

answered Mar 14, 2019 at 11:17

Fahmi

37.5k5 gold badges26 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

bostongeorge Over a year ago

This is working, thank you. I was able to sort the Status as i liked but could not omit one of them.

gen64 · Accepted Answer · 2019-03-14 11:21:07Z

0

There is a missing single quote after 'close. Also, try using status!='deleted' or status<>'deleted'.

answered Mar 14, 2019 at 11:21

gen64

561 silver badge3 bronze badges

2 Comments

Thanos Markou Over a year ago

I don't see that missing quote that you mention.

bostongeorge Over a year ago

Missing quote is my error in the post, that is actually working.

Collectives™ on Stack Overflow

Query with multiple where conditions

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related