Código sql:
Ver original
CREATE 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:
El siguiente error es esteVer original
SELECT 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
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