Esta es mi tabla noticias
Código sql:
Ver originalCREATE TABLE IF NOT EXISTS `noticias` (
`noticia_ID` INT(11) NOT NULL AUTO_INCREMENT,
`noticiaTitulo` VARCHAR(200) NOT NULL,
`noticiaNoticia` text NOT NULL,
`club` VARCHAR(200) NOT NULL,
PRIMARY KEY (`noticia_ID`),
FULLTEXT KEY `buscador` (`noticiaTitulo`,`noticiaNoticia`,`club`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
Ahora en mi script esta es mi query
Código sql:
Ver originalSELECT noticiaTitulo, noticiaNoticia,club
MATCH (noticiaTitulo, noticiaNoticia,club)
AGAINST ('$frase' IN BOOLEAN MODE) AS coincidencias
FROM noticias
WHERE MATCH (noticiaTitulo, noticiaNoticia,club)
AGAINST ('$frase' IN BOOLEAN MODE)
ORDER BY coincidencias DESC
El siguiente error es este
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MATCH (noticiaTitulo, noticiaNoticia,club) AGAINS' at line 2
Y no a q se debe