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