How can i MySQL FullText Search with Sequelize

Viewed 955

i tried :

models.Doctor.findAll({ where: Sequelize.literal(MATCH (fname, lname) AGAINST(ali))});

table:

> CREATE TABLE `doctors` (
  `id` int(11) NOT NULL,
  `fname` varchar(50) COLLATE utf8_persian_ci NOT NULL,
  `lname` varchar(50) COLLATE utf8_persian_ci NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci;

and table alter is

ALTER TABLE doctors ADD PRIMARY KEY (id), ALTER TABLE doctors ADD FULLTEXT KEY fname (fname); ALTER TABLE doctors ADD FULLTEXT KEY lname (lname);

when i tried to execute following query i gote belowe error :

models.Doctor.findAll({
  where: Sequelize.literal(`MATCH (fname, lname) AGAINST(ali)`)
});

error:

Unhandled rejection SequelizeDatabaseError: Can't find FULLTEXT index matching the column list at Query.formatError any body can help?(model and query example please)

0 Answers
Related