Query returning 0 rows, even though rows exist - MySQL

Question

I have a table called parents. It has a column named share_src which is indexed. Currently it is having 5 rows. Three of them have NULL while others have post_4556 as their value.

I am running this statement -: SELECT * FROM parents WHERE share_src != 'post_4556'. It should return those three rows which have share_src as NULL. But it is returning 0 rows.

What is wrong in my query. Thanks for help.

hjpotter92 · Accepted Answer · 2013-03-17 11:38:14Z

2

You need to specify the IS NULL condition to fetch the rows where that particular field may be NULL.

SELECT * 
FROM parents 
WHERE share_src != 'post_4556'
    OR share_src IS NULL;

answered Mar 17, 2013 at 11:38

hjpotter92

81.1k36 gold badges148 silver badges188 bronze badges

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

Comments

Mahmoud Gamal · Accepted Answer · 2013-03-17 11:38:05Z

1

Nothing wrong with your query, this is how NULL values behaves.

Add OR share_src IS NULL to the WHERE clause, in order to return those that has nullable share_src too:

SELECT * 
FROM parents 
WHERE share_src != 'post_4556'
   OR share_src IS NULL;

answered Mar 17, 2013 at 11:38

Mahmoud Gamal

80.3k18 gold badges143 silver badges168 bronze badges

Collectives™ on Stack Overflow

Query returning 0 rows, even though rows exist - MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related