mysql if not null, 0 or ""

mysql isnull
John Magnolia picture John Magnolia · Feb 5, 2013 · Viewed 8.2k times · Source 
SELECT * 
  FROM table WHERE id IN ('21') 
   AND (content_id IS NULL OR content_id = 0 OR content_id = '')

Is there a shorter way of writing this condition.

I have a int() column that could be either: NULL, 0 or EMPTY.

Answer

Pablo Santa Cruz picture Pablo Santa Cruz · Feb 5, 2013

You can use IFNULL function in MySQL.

select ____
  from tbl
 where IFNULL(content_id, 0) = 0

Related questions

MySQL comparison with null value

I have a column called CODE in a MySQL table which can be NULL. Say I have some rows with CODE='C' which I want to ignore in my select result set. I can have either CODE=NULL or CODE!=…

Read More
MySQL - How Do I Count Nulls and Not Nulls?

I have a simple table of installs: prod_code email install_slot If the install_slot is NULL, then it's an available install slot. Not null -- then, used slot. I need to return a result of total installs for …

Read More
MySQL - Selecting rows with null columns

How can I select any row that contains empty or null column? I'm trying to run a check on my table, in which I want to see if any of my rows contain a column that doesn't hold a value.. …

Read More