CREATE TABLE `descriptions` (
  `ind` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `nt` varchar(500) DEFAULT NULL,
  `description` text NOT NULL,
  `sh` int(11) NOT NULL,
  `ush` text NOT NULL,
  `man` int(11) NOT NULL,
  `gost` varchar(100) NOT NULL,
  `brand` int(5) NOT NULL,
  `cat` int(10) NOT NULL,
  `sostav` text NOT NULL,
  PRIMARY KEY (`ind`),
  UNIQUE KEY `code` (`code`),
  KEY `albr` (`cat`,`brand`,`gost`,`man`),
  FULLTEXT KEY `nt` (`nt`)
) ENGINE=MyISAM AUTO_INCREMENT=2451854 DEFAULT CHARSET=utf8;

SELECT c.code,c.name,d.description FROM codes c, descriptions d WHERE MATCH (c.name) AGAINST (\'+'.str_replace(" ", " +", $good).'\' IN BOOLEAN MODE) AND c.code=d.code