[MYSQL] indici fulltext

[LoRdCoStE]

Originariamente inviato da piero.mac

For natural-language full-text searches, it is a requirement that the columns named in the MATCH() function be the same columns included in some FULLTEXT index in your table. For the preceding query, note that the columns named in the MATCH() function (title and body) are the same as those named in the definition of the article table's FULLTEXT index. If you wanted to search the title or body separately, you would need to create separate FULLTEXT indexes for each column.

http://dev.mysql.com/doc/refman/5.0/...-language.html

grazie mille ho risolto, dovevo separare gli indici fulltext, prima erano visti come un unico indice

CREATE TABLE `pages` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `path` varchar(100) NOT NULL,
  `ordine` int(11) NOT NULL,
  `padre` int(11) NOT NULL,
  `title` varchar(150) NOT NULL,
  `en_title` varchar(150) NOT NULL,
  `menu_title` varchar(100) NOT NULL,
  `en_menu_title` varchar(100) NOT NULL,
  `body` text NOT NULL,
  `en_body` text NOT NULL,
  `active` tinyint(1) NOT NULL default '1',
  `menu` varchar(10) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `path` (`path`),
  KEY `padre` (`padre`),
  FULLTEXT KEY `body` (`body`),
  FULLTEXT KEY `title` (`title`),
  FULLTEXT KEY `en_title` (`en_title`),
  FULLTEXT KEY `en_body` (`en_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;