sequelize.query() returns same result twice

Add { type: Sequelize.QueryTypes.SELECT } as the second argument, also remember to import Sequelize first.


The first object is the result object, the second is the metadata object (containing affected rows etc) - but in mysql, those two are equal.

Passing { type: Sequelize.QueryTypes.SELECT } as the second argument will give you a single result object (metadata object omitted

https://github.com/sequelize/sequelize/wiki/Upgrading-to-2.0#changes-to-raw-query


Try :

sequelizeObj.query("SELECT * FROM `reports` WHERE `id` = 1200", { type: Sequelize.QueryTypes.SELECT }).then(function (result) {
    });