SELECT WHERE IN null

Question

Can a SELECT statement use an IN clause to find null values?

For example:

SELECT 
  `TEST`,
  `TEST2`,
  `TEST3`
FROM
  table
WHERE `TEST3` IN ('var1','var2', null)

I need to bring back all records whether they are null or not.

I am not getting any errors, but I am not returning any null values.

How do I make this work?

... and `null` is not a value, not even the absence of a value, but more like "undefined". — The Impaler, Apr 02 '20 at 20:36

score 2 · Accepted Answer · answered Apr 02 '20 at 20:35

2

You'll need to use an OR operator:

SELECT 
  `TEST`,
  `TEST2`,
  `TEST3`
FROM
  table
WHERE `TEST3` IN ('var1','var2') or `TEST3` is null

answered Apr 02 '20 at 20:35

The Impaler

1 Answers1