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'}]}});

  

 

 

posted @ 2019-11-08 17:02  Mr_Kahn  阅读(228)  评论(0)    收藏  举报