Sequelize - case-insensitive like

Question

How can I achieve this in Sequelize?

SELECT * FROM table where lower(column) LIKE ('abcd%'); 

I can't find a way to mix lower function with $like

Answer 1

You should use Sequelize.Op :

Table.findAll({     where: {         name: {             [Sequelize.Op.iLike]: searchQuery         }     } }) 

Don't forget to add % before or after your searchQuery, if you want to make a partial query.

See the docs here