const Op = Sequelize.Op
[Op.and]: {a: 5}
[Op.or]: [{a: 5}, {a: 6}]
[Op.gt]: 6,
[Op.gte]: 6,
[Op.lt]: 10,
[Op.lte]: 10,
[Op.ne]: 20,
[Op.eq]: 3,
[Op.not]: true,
[Op.between]: [6, 10],
[Op.notBetween]: [11, 15],
[Op.in]: [1, 2],
[Op.notIn]: [1, 2],
[Op.like]: '%hat',
[Op.notLike]: '%hat'
[Op.iLike]: '%hat'
[Op.notILike]: '%hat'
[Op.startsWith]: 'hat'
[Op.endsWith]: 'hat'
[Op.substring]: 'hat'
[Op.regexp]: '^[h|a|t]'
[Op.notRegexp]: '^[h|a|t]'
[Op.iRegexp]: '^[h|a|t]'
[Op.notIRegexp]: '^[h|a|t]'
[Op.like]: { [Op.any]: ['cat', 'hat']}
[Op.overlap]: [1, 2]
[Op.contains]: [1, 2]
[Op.contained]: [1, 2]
[Op.any]: [2,3]
[Op.col]: 'user.organization_id'
因为习惯打开csdn找东西,所以转载。
侵删,转自
https://www.jianshu.com/p/76ea6b985abb
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)