Mysql not selecting null values [duplicate]

Question

I have the following query:

SELECT * FROM table 
WHERE orderdate >= "2015-12-01" 
    AND orderdate <= "2015-12-31" 
    AND values > 0 
    AND orders <> 'Returned'

The problem is that the query doesn't return the rows where the orders column is NULL and I can't figure out why.

NULL is considered unknown value so it is not equal or unequal with anything.You want ...AND (orders <> 'Returned' OR orders IS NULL) Also VALUES is a reserved word — Mihai
– Mihai, Commented Jan 7, 2016 at 20:55

Barmar · Accepted Answer · 2016-01-07 21:08:16Z

3

This is the sql language. Mysql doesn't consider NULL as value. So if you want to include NULL we must specify that.

SELECT * FROM table 
WHERE orderdate >= "2015-12-01" 
    AND orderdate <= "2015-12-31" 
    AND values > 0 
    AND (orders <> 'Returned' or orders is null)

edited Jan 7, 2016 at 21:08

Barmar

789k57 gold badges555 silver badges669 bronze badges

answered Jan 7, 2016 at 20:56

Aviad

1,5491 gold badge9 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

Mysql not selecting null values [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related