sequelize not equal code example
Example 1: sequelize limit
const Op = Sequelize.Op;
app.get('/notes/search', function(req, res) {
Note.findAll({
limit: 2,
where: {
tag: {
[Op.or]: [].concat(req.query.tag)
}
}
}).then(notes => res.json(notes));
});
Example 2: sequelize order by
order: [["createdAt", "DESC"]]
Example 3: sequelize like search
const Sequelize = require('sequelize');
const Op = Sequelize.Op;
let data: Array = await MyDataSequelizeAccess.findAll({
where: {
name: {
[Op.like]: '%Bob%'
}
}
});
Example 4: sequelize not equal
const { Op } = require("sequelize");
column: {[Op.ne]: value},