sequelize特殊写法,与之对应的SQL
1. 查找某一表中两字段相同的记录
例如:查找表engineering中uuid与uid相等,且name为“工程1”的记录
SQL : select * from engineering where engineering.uuid = engineering.uid and name = '工程1';
await model.Engineering.findAll({where: {[op.and]:[sequelize.where(sequelize.col('uid'), sequelize.col('uuid')), {name: '工程1'}]}});

浙公网安备 33010602011771号