Can't find FULLTEXT index matching the column list: SELECT *, MATCH (es, es_txt, tags) AGAINST ("s-arenal" IN BOOLEAN MODE ) AS ScoreAll, MATCH (es, tags) AGAINST ("s-arenal" IN BOOLEAN MODE ) AS ScoreMedium, MATCH (es) AGAINST ("s-arenal" IN BOOLEAN MODE ) AS ScoreTitle FROM noticias WHERE publicar != "" && archivo != 1 && papelera != 1 && publicada = 1 && publicar <= "2021-05-12 00:14:59" && MATCH(es, es_txt, tags) AGAINST("s-arenal" IN BOOLEAN MODE) ORDER BY ScoreAll + ScoreMedium + ScoreTitle DESC limit 100