Node sequelize where or query example

Hello Friends,

Welcome To Infinitbility!

This article based on where or query in node sequelize, here you will get example of where or query.

Sequelize provide operator functionality to manage this types of query.

For using operator you have to import op from sequelize like below.

Copy 
1const { Op } = require("sequelize");

For using or condition we have to Op.or in where condition like below example.

Copy 
1const { Op } = require("sequelize");
2Post.findAll({
3  where: {
4    [Op.or]: [
5      { authorId: 12 },
6      { authorId: 13 }
7    ]
8  }
9});

Where or query output

Copy 
1// SELECT * FROM post WHERE authorId = 12 OR authorId = 13;

Subscribe Our Newsletter You will get monthly free programming book