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
doctorsADD PRIMARY KEY (id), ALTER TABLEdoctorsADD FULLTEXT KEYfname(fname); ALTER TABLEdoctorsADD FULLTEXT KEYlname(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)