sequelize not equal example
Example 1: op in sequelize
//First method
// selecting authorityId :12 or 13
model.findAll({
where: {
[Op.or]: [
{ authorId: 12 },
{ authorId: 13 }
]
}
});
Example 2: sequelize .all()
yourTableModel.findAll({
//optional filters
where: {},
raw: true,
})
Example 3: sequelize not equal
const { Op } = require("sequelize");
column: {[Op.ne]: value},
Example 4: sequelize where more than
// Number comparisons
[Op.gt]: 6, // > 6
[Op.gte]: 6, // >= 6
[Op.lt]: 10, // < 10
[Op.lte]: 10, // <= 10
[Op.between]: [6, 10], // BETWEEN 6 AND 10
[Op.notBetween]: [11, 15], // NOT BETWEEN 11 AND 15