MySQL AND/OR SELECT Statement multiple values in field

Question

I have a simple enough query that works well:

SELECT 
     Name, JobStatus 
FROM 
     ScheduleRequest
WHERE
     ScheduleDate >= '2018-07-11' 
AND 
     JobStatus <> 6

I need to check for different values in the same field 'JobStatus'. When I try to alter the query like this, I'm finding only the last value of 95 is showing?

SELECT 
     Name, JobStatus
FROM 
    ScheduleRequest
WHERE
    ScheduleDate >= '2018-07-11' 
    AND (JobStatus <> 6 
        OR JobStatus <> 0 
        OR JobStatus <> 1
        OR JobStatus <> 4
        OR JobStatus <> 95
    )

Notice how everything will match as no record can have all of the values assigned to a single filed. What you wanted probably is to either use AND instead of OR or just use the proposed answer with NOT IN. — orhtej2
– orhtej2, Commented Jul 11, 2018 at 20:03

dee.ronin · Accepted Answer · 2018-07-11 20:43:29Z

3

Use NOT IN expression

SELECT 
     Name, JobStatus
FROM 
    ScheduleRequest
WHERE
     ScheduleDate >= '2018-07-11' 

    AND JobStatus NOT IN (6, 0, 1, 4, 95)

edited Jul 11, 2018 at 20:43

dee.ronin

1,03812 silver badges22 bronze badges

answered Jul 11, 2018 at 19:50

Pankaj Gadge

2,8443 gold badges21 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

MySQL AND/OR SELECT Statement multiple values in field

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related