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