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},

Tags:

Misc Example