MySQL Full Text Search using few Columns

[natasha_sharma]

Hi,

 

I used below code to create Fulltext search index on my table:

ALTER TABLE company_info ADD FULLTEXT INDEX comp (industry, product_group, products, raw_material, business_desc, gisc_ind_2) 

I want to calculate score using only product_group variable. So i am using below query:

select MATCH(product_group) AGAINST ( ' +shrimp' IN BOOLEAN MODE) as score from company_info WHERE isin='abcd' AND  MATCH(industry, product_group, products, raw_material, business_desc, gisc_ind_2) AGAINST ( '     +shrimp' IN BOOLEAN MODE)

Error: mariaDB "can not find fulltext index matching the column list"

 

 

I know I create fulltext index on multiple columns, so i can use any column i want in future.

 

But right now I want to calculate score variable using "product_group" variable only.

 

How Can i do that?