mysqlnullwhere-clausedata-analysisexploratory-data-analysis

WHERE columnName IS NULL but Not Getting Expected Result

I am only starting my first project for my portfolio and I am completely bamboozled...

During my EDA, I noticed the continents column with NULL values are good for queries specifically about continents as the corresponding population column has the total figure of the population, regardless of the date.

So I want to look at countries only (location column) by filtering out the NULL values in the continent column:

SELECT 
    *
FROM
    covidDeaths
WHERE continent IS NOT NULL
ORDER BY
    date asc;

However, when I do this, the NULL values still show up in the result table.

However, when I do this, the NULL values still show up in the result table.

Solution

  • My guess is that those values are not NULL but they are empty strings.