Similar words
Posted: Thu Sep 01, 2005 7:51 am
Hello all!
This is the structure of my mysql table:
CREATE TABLE `terms` (
`termID` int(10) unsigned NOT NULL auto_increment,
`keyword` text,
`date` date default NULL,
`type` enum('web','images','news','video','audio','shopping') default 'web',
`count` int(11) default NULL,
PRIMARY KEY (`termID`)
) TYPE=MyISAM AUTO_INCREMENT=50242 ;
and some records...
INSERT INTO `terms` VALUES (1, '12+more', '2005-08-03', 'web', 408);
INSERT INTO `terms` VALUES (2, 'sexy+3gp', '2005-08-03', 'video', 88);
INSERT INTO `terms` VALUES (3, 'download+crack+mp3', '2005-08-03', 'web', 73);
INSERT INTO `terms` VALUES (4, 'me', '2005-08-03', 'audio', 28);
INSERT INTO `terms` VALUES (5, 'time+public', '2005-08-03', 'web', 168);
INSERT INTO `terms` VALUES (6, 'hussyfan+pthc', '2005-08-03', 'web', 122);
INSERT INTO `terms` VALUES (7, 'child+hentai', '2005-08-03', 'images', 66);
INSERT INTO `terms` VALUES (8, 'remix', '2005-08-03', 'web', 167);
... i have more then 50.000 records...
What i need...
I have some words, for example: music+remix+mp3
And..i want to display the similar words from table(row keyword)!
The first 20 phrases from mysql table that contain music or remix or mp3
You understand?
Thanks!
This is the structure of my mysql table:
CREATE TABLE `terms` (
`termID` int(10) unsigned NOT NULL auto_increment,
`keyword` text,
`date` date default NULL,
`type` enum('web','images','news','video','audio','shopping') default 'web',
`count` int(11) default NULL,
PRIMARY KEY (`termID`)
) TYPE=MyISAM AUTO_INCREMENT=50242 ;
and some records...
INSERT INTO `terms` VALUES (1, '12+more', '2005-08-03', 'web', 408);
INSERT INTO `terms` VALUES (2, 'sexy+3gp', '2005-08-03', 'video', 88);
INSERT INTO `terms` VALUES (3, 'download+crack+mp3', '2005-08-03', 'web', 73);
INSERT INTO `terms` VALUES (4, 'me', '2005-08-03', 'audio', 28);
INSERT INTO `terms` VALUES (5, 'time+public', '2005-08-03', 'web', 168);
INSERT INTO `terms` VALUES (6, 'hussyfan+pthc', '2005-08-03', 'web', 122);
INSERT INTO `terms` VALUES (7, 'child+hentai', '2005-08-03', 'images', 66);
INSERT INTO `terms` VALUES (8, 'remix', '2005-08-03', 'web', 167);
... i have more then 50.000 records...
What i need...
I have some words, for example: music+remix+mp3
And..i want to display the similar words from table(row keyword)!
The first 20 phrases from mysql table that contain music or remix or mp3
You understand?
Thanks!