Is there a way to order by where in field?

[giiska]

The sql is like this:

SELECT
    `id`,
    `name`
FROM
    `members` AS `member`
WHERE
    `member`.`id` IN('40', '44', '41', '42', '43', '45')
ORDER BY FIELD(`member`.`id`,'40', '44', '41', '42', '43', '45')

How to get this done by Sequelize ?

[mickhansen]

order: [[sequelize.fn('FIELD', sequelize.col('member.id'), '40', 44', '...'))]] should work.

[giiska]

@mickhansen Thanks, it's work.

[Shivam-svelte]

order: [[sequelize.fn('FIELD', sequelize.col('member.id'), '40', 44', '...'))]] should work.

work for me try this

[developersaif]

I tested this and it worked for me.

order: [[fn("FIELD", col("products.id"), [2, 3, 1])]]