QUgSn2m0

1CREATE TABLE IF NOT EXISTS `questions` (
2  `question_id` int(11) NOT NULL auto_increment,
3  `program_id` int(11) default NULL,
4  `question` text,
5  `answer` text,
6  `publish` tinyint(1) default NULL,
7  `created_at` datetime default NULL,
8  `updated_at` datetime default NULL,
9  PRIMARY KEY  (`question_id`),
10  KEY `index_questions_on_program_id` (`program_id`),
11  FULLTEXT KEY `question` (`question`,`answer`)
12) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3078 ;
13
14
15QUERY:
16
17SELECT * FROM `questions` where match (quesiton, answer) against ('some materials')