FREE AI-Enhanced Online MySQL Compiler - For learning & practice

Untitled*

You must execute the code again to save those values in the database.

-- ----------------------------
-- Table structures
-- ----------------------------
DROP TABLE IF EXISTS `a`;
CREATE TABLE `a` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `search1` varchar(255) NOT NULL,
  `search2` varchar(255) NOT NULL,
  `popularity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT `f` (`search1`,`search2`),
  INDEX `popularity` (`popularity`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of a
-- ----------------------------
INSERT INTO `a` VALUES ('1','aa sadd','aa',7);
INSERT INTO `a` VALUES ('2','abcd aasdadd sads','aa',8);
INSERT INTO `a` VALUES ('3','aa daa','aaf df',9);
INSERT INTO `a` VALUES ('4','aa sad','aadf ',3);
INSERT INTO `a` VALUES ('5','aa v abcd','aaxcv',23);
INSERT INTO `a` VALUES ('6','aa c','aavv',55);
INSERT INTO `a` VALUES ('7','aa df','aaaa',54);
INSERT INTO `a` VALUES ('8','aa df','aa s',67);
INSERT INTO `a` VALUES ('9','aa vvv','a a',7);
INSERT INTO `a` VALUES ('10','ss','aaaa abcd',74);

ALTER TABLE a ORDER BY `popularity` DESC;

# poulrity DESC
SELECT id, popularity FROM a WHERE MATCH (`search1`,`search2`) AGAINST ('abcd' IN BOOLEAN MODE) LIMIT 5;

ALTER TABLE a ORDER BY `popularity`;

# poulrity ASC
SELECT id, popularity FROM a WHERE MATCH (`search1`,`search2`) AGAINST ('abcd' IN BOOLEAN MODE) LIMIT 5;

id	popularity
10	74
5	23
2	8

id	popularity
2	8
5	23
10	74