mQ0H2ym1

1SELECT * FROM `videos` WHERE MATCH (name,tags) AGAINST ('mytag' IN BOOLEAN MODE) LIMIT 20
2	
3SELECT COUNT(*) AS `numrows` FROM `videos` WHERE MATCH (name,tags) AGAINST ('mytag' IN BOOLEAN MODE)
4	
5DROP TABLE IF EXISTS `videos`;
6CREATE TABLE `videos` (
7`id` int(11) NOT NULL AUTO_INCREMENT,
8`name` varchar(255) NOT NULL,
9`name_url` varchar(255) DEFAULT NULL,
10`categories` varchar(255) DEFAULT NULL,
11`embed` tinytext,
12`description` text,
13`tags` varchar(255) DEFAULT NULL,
14`hd` smallint(6) DEFAULT '0',
15`views` int(11) NOT NULL DEFAULT '0',
16`likes` int(11) DEFAULT '0',
17`dislikes` int(11) DEFAULT '0',
18`cover` varchar(255) DEFAULT NULL,
19 PRIMARY KEY (`id`,`name`),
20 FULLTEXT KEY `categories` (`categories`),
21 FULLTEXT KEY `name` (`name`),
22 FULLTEXT KEY `tags` (`tags`)
23) ENGINE=MyISAM AUTO_INCREMENT=1273355 DEFAULT CHARSET=latin1;