Multiple where in mysql query not returning anything

Question

I know that this is a very easy question, but why isn't my query returning anything ?

mysql> select * from notifications;
+----+---------+-------------+---------+--------+---------------------+
| id | user_id | sec_user_id | item_id | action | date                |
+----+---------+-------------+---------+--------+---------------------+
|  1 |       1 |        NULL |    NULL |   NULL | 2015-10-09 23:47:36 |
+----+---------+-------------+---------+--------+---------------------+
1 row in set (0.00 sec)

mysql> select id from notifications where user_id = 1 and action = NULL;
Empty set (0.00 sec)

vidit · Accepted Answer · 2015-10-10 04:31:29Z

1

NULL cannot be equal to anything, including itself. You should use is with it..

select id from notifications where user_id = 1 and action is NULL;

edited Oct 10, 2015 at 4:31

answered Oct 10, 2015 at 4:22

vidit

6,5013 gold badges36 silver badges50 bronze badges

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

Comments

Chuck · Accepted Answer · 2015-10-10 04:59:51Z

0

Change action = null to action is null.

edited Oct 10, 2015 at 4:59

Chuck

4,9782 gold badges36 silver badges64 bronze badges

answered Oct 10, 2015 at 4:22

Timothy Stepanski

1,1947 silver badges22 bronze badges

Comments

Chuck · Accepted Answer · 2015-10-10 05:00:16Z

0

try with IS NULL:

select id 
from notifications 
where user_id = 1 
and action IS NULL

edited Oct 10, 2015 at 5:00

Chuck

4,9782 gold badges36 silver badges64 bronze badges

answered Oct 10, 2015 at 4:22

Hotdin Gurning

1,8193 gold badges16 silver badges24 bronze badges

Collectives™ on Stack Overflow

Multiple where in mysql query not returning anything

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related