search in sequelize code example
Example 1: sequelize order by
order: [["createdAt", "DESC"]]
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 OR
"SELECT * FROM Student WHERE LastName='Doe' OR FirstName in ("John","Jane") OR Age>18"