CREATE TABLE IF NOT EXISTS `listing` (
  `Listing_ID` MEDIUMINT unsigned NOT NULL auto_increment,
  `Name` varchar(80) character set utf8mb4 NOT NULL,
  `Location` varchar(100) character set utf8mb4 NOT NULL,
  PRIMARY KEY  (`Listing_ID`),
  FULLTEXT (`Name`),
  FULLTEXT (`Location`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8mb4 ;

CREATE TABLE IF NOT EXISTS `categories` (
  `Category_ID` SMALLINT unsigned NOT NULL auto_increment,
  `Category_Name` varchar(80) character set utf8mb4 NOT NULL,
  PRIMARY KEY  (`Category_ID`),
  FULLTEXT (`Category_Name`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8mb4 ;

CREATE TABLE IF NOT EXISTS `listing_relations` (
  `Listing_ID` MEDIUMINT unsigned NOT NULL,
  `Category_ID` SMALLINT unsigned NOT NULL,
  UNIQUE INDEX (Listing_ID, Category_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

Table `Listing`
Listing_ID       Name              Location
1                Jack I Sales       Milan
2                Jimmy Sales        NY

Table   `categories`
Category_ID         Category_Name
1                      Iphone Dealer
2                      Samsung Mobile Dealer
3                      Mobile Dealer
4                      Iphone Apps
5                      Iphone Cover Dealer

table `listing_relations`
Listing_ID     Category_ID
1                1
1                5
1                4
2                2
2                3

Listing_ID       Name              Location           Category_Name
1                Jack I Sales       Milan               Iphone Dealer, Iphone Cover Dealer

Listing_ID       Name              Location           Category_Name
1                Jack I Sales       Milan               Iphone Dealer, Iphone Cover Dealer, Iphone Apps
2                Jimmy Sales        NY                  Samsung Mobile Dealer, Mobile Dealer,

SELECT *, MATCH(Category_Name) AGAINST("+Iphone +dealer" IN BOOLEAN MODE) AS Score FROM categories where MATCH(Category_Name) AGAINST("+Iphone +dealer" IN BOOLEAN MODE) having score>0 ORDER BY score Desc