Sequelize mysql query where attribute is null

Question

I have an address and I want to see if it's in the db already, if not, create a new one. I know I can use findOrCreate() here, but let's make it easy and just check why I can't even find the existing address.

  var address = {
    name: req.body.name,
    address1: req.body.address1,
    address2: req.body.address2,
    zip: req.body.zip,
    city: req.body.city,
    country: req.body.country,
    user_id: req.body.user_id
  };

  Address.find({where: address}).then(function(result){
    console.log(result);
  }).catch(function(err){
    console.error(err);
  });

The generated query asks for ... AND user_id = NULLwhich is wrong. It should ask ... AND user_id IS NULL. How can I let sequelize do it right for me? Thanks.

Ivan Drinchev · Accepted Answer · 2016-10-13 14:19:20Z

5

You should just use the JavaScript null primitive.

var address = {
    name: req.body.name,
    address1: req.body.address1,
    address2: req.body.address2,
    zip: req.body.zip,
    city: req.body.city,
    country: req.body.country,
    user_id: req.body.user_id || null
};

This will generate the query

... user_id IS NULL

Additional information

model.findAll( { where: { some_column : undefined } } );

will generate

... WHERE `some_column` = NULL

answered Oct 13, 2016 at 14:19

Ivan Drinchev

19.6k4 gold badges69 silver badges97 bronze badges

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

3 Comments

molerat Over a year ago

Thanks for your reply, I will test this soon.

John Vandivier Over a year ago

upvoted. btw you can also use null directly: model.findAll( { where: { some_column : null } } );

MathKimRobin Over a year ago

Must use "null"

Collectives™ on Stack Overflow

Sequelize mysql query where attribute is null

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related