sequelize where like code example
Example 1: op in sequelize
model.findAll({
where: {
[Op.or]: [
{ authorId: 12 },
{ authorId: 13 }
]
}
});
Example 2: sequelize like search
const Sequelize = require('sequelize');
const Op = Sequelize.Op;
let data: Array<any> = await MyDataSequelizeAccess.findAll({
where: {
name: {
[Op.like]: '%Bob%'
}
}
});
Example 3: sequelize .all()
yourTableModel.findAll({
where: {},
raw: true,
})
Example 4: sequelize not equal
const { Op } = require("sequelize");
column: {[Op.ne]: value},